Double vlookup - lookup into 2 different column

S

spari77

Hi
I have a raw data as below:-
ID Num STATION RESULTS DETAIL1
A 1 PASS
A 2 PASS
A 3 FAIL NO CONNECTION
B 1 PASS
C 1 FAIL NO POWER
C 2 PASS
D 1 PASS
D 3 FAIL SOUND
F 1 PASS
F 3 PASS
B 2 PASS
D 2 FAIL
F 2 PASS
B 3 PASS

How do i do a vlookup table (in a separate sheet) to return me th
value of ColumnC (Results) for the below
ID Num Station1 STATION2 STATION3
A PASS PASS FAIL
B ...... ....... .......

Please help Neeed this fast
 

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

Similar Threads

Checking the results of a number of IF formula 4
lookup two different variables 0
Vlookup formula combining two columns 2
IF Statement with AND Statement 4
Match & Vlookup Function 1
If Statement to display 3 different outputs instead of 2 5
How to give count of lines before all 5 values pass?? 18
Excel VBA macro, search - accumulate - delete original 0

Top