VLOOKUP for Specific Text in One Table Where an ID Matches in Another Table

**towanda7** · 06-04-2013, 10:54 AM

Hi there. I am trying to use some combination of IF and VLOOKUP to pull back a status field based on a location ID, and I am not having much luck.

In Table2, I have a list of devices associated with locations, and each has a LocationID that corresponds back to Table1, which contains the location data, including LocationID and LocationStatus. What I need to do is use the LocationID from Table2 to match back to the corresponding LocationID in Table1 and return the text from the LocationStatus field for entries ONLY with the LocationStatus of "Ordered".

I realize this is probably really simple, but I am new to the world of VLOOKUP. Any help is appreciated.

**krjoshi** · 06-04-2013, 11:04 AM

Hi towanda7,

Please upload a sample workbook with some data. I will look at it.

**BenMiller** · 06-04-2013, 11:11 AM

Assuming sheet1 has location ID in column A and location status in column B. Assumin sheet 2 has location ID in column D, starting in D2. Put this in a new column on sheet 2:

=VLOOKUP(D2,Sheet1!A:B,2,0)

Let us know your actual ranges and we'll change the formula.

**towanda7** · 06-04-2013, 11:17 AM

Thank you. Doesn't that just return LocationStatus for all entries regardless of the value of that status? I would like it to only return data where LocationStatus is "Ordered".

The data on sheet one is formulated as Table1 and has 6 columns. Column A is LocationID, and Column E is LocationStatus.

The data on sheet two is formulated as Table2 and has LocationID in Column A.

I was using =VLOOKUP(A2,Table1,5,FALSE), which gave me back a LocationStatus value for all rows, then I was just filtering to get to "Ordered", but I would prefer it only return results where LocationStatus = "Ordered".