Formula for Vlookup to refer more than 2 excel sheets?

M

Max

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
---
 

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