vlookup and if on two lists of text

[adame]

Hi all, apologies for my ignorance but trying to find a way to do a lookup on two columns of different text data and to return a numeric value in an adjacent cell if there's a match - wherever that match might be. i.e.
A B
1pm 9.00 1pm
3i Group 750.00 3i Group
Shell 29.0 4imprint Group
4imprint Group 7.0

So my formula would return a 9.00 next to the 1pm in 'B', a 750 next to 3i Group and wherever the 4imprint Group is in 'A' would return the 7 next to 4imprint Group in B.

Hope that makes sense, I know there's an easy way to do this. Thanks a lot

Adam

[zbor]

See this, is this what you want?

on sheet2 you have defined values (alphabeticaly sorted), and on sheet1 you get results

Book1.xls

[adame]

zbor, thanks for superfast response - I think you're reply almost gets it but my initial explanation might have been unclear.

I have attached an example - it would be a straightforward vlookup but there are different data in the two lists.

Thanks

Adam

[zbor]

So, B is correctly populated and you want to populate column E?

=VLOOKUP(D2;$A$2:$B$17;2;FALSE)

(maybe you need replace ; with ,)

This will give you error in last 3 cells because cell doesn't match

[adame]

Great, thanks a lot zbor - kudos to you! Have a great day!
Adam