Previous Topic Next Topic

Vlookup

Solved/Closed
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jan 5, 2011 at 04:57 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jan 9, 2011 at 10:47 PM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jan 7, 2011 at 09:35 AM
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
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012
Jan 9, 2011 at 10:47 PM
TX Trowa

It works well!
0

Similar discussions

Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses