Multiple VLOOKUP's

[PVGoshia]

I have a three sheet worksheet and on Sheet "1" I am doing VLOOKUP's over to Sheet 'UL1703 Re-Test WS' as seen below. So with the formuls below if F6="Y" my VLOOKUP goes to line "7" of the worksheet and populates the colunm. My question is how do I get the lookup to work with 2 or more LOOKUP's in one command.

=IF(F6="Y",VLOOKUP(7,'UL1703 Re-Test WS'!A1:B23,2,FALSE))

 

[Arcticwarrio]

You should have

=IF(F6="Y",VLOOKUP(7,'UL1703 Re-Test WS'!A1:B23,2,FALSE),"")

assuming Column A has numbers in them 1,2,3,4,5,6,7 etc

so if F6 is not Y then also vlookup another value?

=IF(F6="Y",VLOOKUP(7,'UL1703 Re-Test WS'!A1:B23,2,FALSE),VLOOKUP(1,'UL1703 Re-Test WS'!A1:B23,2,FALSE))

 

[PVGoshia]

Yes Column A are number 1,2,3,4,5....

However changing the formula by just adding a comma the adding the same VLOOKUP(1,UL1703 Re-Test WS'!A1:B23,2,FALSE)) and only changing the number to lookup only returns me the first lookup not both?

 

[Arcticwarrio]

what 2nd lookup do you want like get rows 6 & 7 in the same cell?

=IF(F6="Y",VLOOKUP(6,'UL1703 Re-Test WS'!A1:B23,2,FALSE)&VLOOKUP(7,'UL1703 Re-Test WS'!A1:B23,2,FALSE) ,""))

 

[PVGoshia]

So when the VLOOKUP work for search "1" in returns to sheet 1 (Temp Test) and if I could get second aggument to work I would like with both of them working return "Temp Test, Damp Heat Test" (1,7) in the lookup.

 

[Arcticwarrio]

=IF(F6="Y",VLOOKUP(1,'UL1703 Re-Test WS'!A1:B23,2,FALSE)&", "&VLOOKUP(7,'UL1703 Re-Test WS'!A1:B23,2,FALSE) ,""))</pre>