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.