Vlookup only IF condition2 is met, pls help..Desperate Situation!!

S

spari77

Hello
I would like to do a Vlookup and return a value only if 2nd conditio
is met.
Pls see the attched file.
The data that i have are all duplicated since a serial num could b
tested at different test station.
What i need to do is:
For Serial Num A, display test results of Station 1 , 2, 3 in the sam
row.
I guess, i have to Vlookup into the Serial Num (condition1) an
Vlookupinto the test station (condition2), but how do we do a doubl
vlookup?

Thank YOU very much...desperately need this solution.

Attachment filename: excel forum.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54026
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top