VLOOKUP to return value found in 1 of 4 columns to a different column in same row

Hello,

I am trying to use VLOOKUP to return a value found in one of four columns to the "end" column where I want the data to display. The table array is matching one corresponding value from one column to the adjacent column. I am able to get the value to display if I only reference one cell, like this:

=VLOOKUP(C9,$A$2:$B$4,2,FALSE)

However, you'll see in the attached worksheet that I essentially want the VLOOKUP to search across four columns, like this:

=VLOOKUP(C9:F9,$A$2:$B$4,2,FALSE)

But the error in the cell is: #VALUE!

Additionally, I want to be able to drag the formula down multiple rows, only displaying one corresponding value. Perhaps VLOOKUP isn't the correct formula? I would appreciate any and all help. Thank you!

Thank you! Your solution was excellent!

Hey there, I realize this thread has been marked "solved" but here's another (a bit more simple) solution if you like.

Thanks

RVUs v2.xlsx

Thank you.

Hello,
I just went back to use this formula and for some reason it is not working anymore. I'm using Excel 2003. Is there some reason to explain why this has happened?
Thank you!

This one:

=IF(C8<>"",VLOOKUP(C8,$A$2:$B$4,2,FALSE),IF(D8<>"",VLOOKUP(D8,$A$2:$B$4,2,FALSE),IF(E8<>"",VLOOKUP(E8,$A$2:$B$4,2,FALSE),IF(F8<>"",VLOOKUP(F8,$A$2:$B$4,2,FALSE),"No Value in all 4 columns"))))

I'll also attach the spreadsheet I have... Maybe the formatting is interfering with the formula? As you can see in the spreadsheet, after inputting the formula and trying to put the code into one of the columns, the number doesn't change in the appropriate column like it was doing before. Thanks for your help!

Hi

you put the cursor omn the cell and press f2 key then press ctrl, shift and entr keys simultanuously. You will get the result.

Hope it will satisfy you.

Regards

desikan

Here's the other lookup function in this new file...thanks.

Test sheet_RVUs.xls

Thanks to everyone for all of your help!