Vlookup Help - Please

[sebell]

Hello,
I am wanting to vlookup based on 2 fields, but don't know if it is possible.

For example I have worksheet A that I am wanting to perform the vlookup in for Columns A & B

My named range is in Worksheet B for columns A, B, & C

I want to match up Columns A & B in both worksheets and grab column c fromt the range.

Is there any way to vlookup based on 2 fields rather than only 1. I hope this makes sense.

Thank you,
Sherry

 

[jdhilljr]

CONCATENATE the cells together on both sheets and then vlookup.

Jim

 

[sebell]

I actually just thought of that. I hope it works, thank you.

 

[SQLScholar]

should be fine as long as you fulfil all other Vlookup criteria (i.e. must have this value as col1, must be sorted by this col)

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!