jojo said:
i need to know what will be the formula for refering 3 spreadsheets in Vlookup?
Assume Sheet2, Sheet3 & Sheet4 (identically structured)
contain the vlookup reference table in cols A & B
Assume you want to vlookup the 3 sheets in this sequence:
Sheet2 first, then Sheet3, then Sheet4
In Sheet1,
you have the lookup values in A2 down
You could put this in B2 (all in one cell, decomposed for clarity):
=
IF(ISNA(VLOOKUP(A2,Sheet2!A:B,2,0)),
IF(ISNA(VLOOKUP(A2,Sheet3!A:B,2,0)),
IF(ISNA(VLOOKUP(A2,Sheet4!A:B,2,0)),"",
VLOOKUP(A2,Sheet4!A:B,2,0)),
VLOOKUP(A2,Sheet3!A:B,2,0)),
VLOOKUP(A2,Sheet2!A:B,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
