Vlookup cross sheet help

Greetings! I am struggling with a vlookup formula.

I want to auto-populate data the IPC Name and IPC Email from sheet 2 based on the campus entered in sheet 1.

I have tried variations and keep getting invalid data type. Help

=VLOOKUP([Campus]@row, {Sheet2 3}, {Sheet2 2}, false)

Find more posts tagged with

The basic formula is =VLOOKUP(search_value,lookup_table,column_num,[match_type]

Here's the formula you need:

=IFERROR(VLOOKUP(Campus@row, {Sheet 2 Range 1}, 2, false), "No Match")

SS Vlookup.PNG

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…