Vlookup

Solved/Closed
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Hello, Please help!

I have 4 columns A,B,C & D(sheet2)Col A got names and B a value for the name in A,Col C names and D values for the names in C. In sht1 i use Cell D7(Sheet1). In D7 is dropdown list with names that is in Sheet2 Col A & C. In Sht1 D21 i want to see the value of name in D7 whether the name is in col A or C on sht2.

A--------------B--------------C------------------D
cable-------401-12-01---bolt-------------403-01-02

So if the name bolt appear in D7, 403-01-02 must be in D21 sht1.

Used the below but i need to combine them!

=VLOOKUP(D7,Sheet2!A2:B164,2,FALSE)
=Vlookup(D7,Sheet2!C2:D164,2,FALSE)

P

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Gouws,

Try this:
=IF(ISERROR(VLOOKUP(D7,Sheet2!A2:B164,2,FALSE)),VLOOKUP(D7,Sheet2!C2:D164,2,FALSE),VLOOKUP(D7,Sheet2!A2:B164,2,FALSE))

Best Regards,
Trowa
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012

TX Trowa

It works well!