how to make multiple vlookup?

[vengatvj]

i want know how to make multiple vlookup. I know vlookup. I want lookup like this.. I have 2excel files. First i want look up in excel 1, if no data in excel 1 then lookup in excel 2. Then give result. If no data in excel 2, then show #N/A. Please explain step by step.

[XOR LX]

Hi,

=IF(ISNA(VLOOKUP(lookup_value,[Book1.xlsx]Book1_range,Book1_col_index_number,range_lookup)),VLOOKUP(lookup_value,[Book2.xlsx]Book2_range,Book2_col_index_number,range_lookup))

where Book1 and Book2 should obviously be amended to match your filenames.

Regards

[Pete_UK]

You would need a construct like this:

=IFERROR(first_lookup,second_lookup)

where first_lookup is looking at excel1 and second_lookup is looking at excel2.

Hope this helps.

Pete

[vengatvj]

hi XOR LX,
in your forumula give result FALSE, i need result , is there anyother forumula?

[vengatvj]

your formula not working, pls tell me breifly.

[XOR LX]

I would need to see how you've adapted it so suit your ranges/sheet names, ideally in an attached Excel sheet, in order to tell you why it is giving you a FALSE result.

Regards

[AlKey]

Here is an example of VLOOKUP for two sheets:

=IFERROR(VLOOKUP(A1,Sheet2!$A$1:$C$18,3,0),VLOOKUP(A1,Sheet3!$A$1:$C$18,3,0))

[vengatvj]

hi all, problem solved, i tried your formula its working, thanks to all.

[vengatvj]

hi alkey i tried three lookup, its not working, just give me some example to write three , four lookups.. please...

[Pete_UK]

This is the general approach:

=IFERROR(first_lookup,second_lookup)

=IFERROR(first_lookup,IFERROR(second_lookup,third_lookup))

=IFERROR(first_lookup,IFERROR(second_lookup,IFERROR(third_lookup,fourth_lookup)))

and so on.

Hope this helps.

Pete

[vengatvj]

pete_uk, this formula is working, pls tell me three four lookup, give me example like this =IFERROR(VLOOKUP(A1,Sheet2!$A$1:$C$18,3,0),VLOOKUP(A1,Sheet3!$A$1:$C$18,3,0))

[AlKey]

For three lookups:

=IFERROR(VLOOKUP(A1,Sheet2!$A$1:$C$18,3,0),IFERROR(VLOOKUP(A1,Sheet3!$A$1:$C$18,3,0),VLOOKUP(A1,Sheet4!$A$1:$C$18,3,0)))

Four lookups:

=IFERROR(VLOOKUP(A1,Sheet2!$A$1:$C$18,3,0),IFERROR(VLOOKUP(A1,Sheet3!$A$1:$C$18,3,0),IFERROR(VLOOKUP(A1,Sheet4!$A$1:$C$18,3,0),VLOOKUP(A1,Sheet5!$A$1:$C$18,3,0))))

[vengatvj]

hi, i want to know three or four lookup,
i attached a file, please make lookup in sheet1 , sheet 2, sheet 3 shee4 datas there.

[Tony Valko]

If you have "many" sheets to check I think you're better off using a separate formula for each sheet and then pulling the result from the separate formulas.

[ramananhrm]

Change the sheet names in the cell marked in red.

[vlady]

Basically post number 12 & 10 will give you what you want. you just have to change the references.
so the given formula would be
In sheet1 B4 fill formula down
=IFERROR(IFERROR(VLOOKUP(A4,venkat!$A$1:$B$2,2,0),IFERROR(VLOOKUP(A4,santhosh!$A$1:$B$2,2,0),IFERROR(VLOOKUP(A4,vinoth!$A$1:$B$2,2,0),VLOOKUP(A4,Sheet5!$A$1:$B$2,2,0)))),"")


note: Sheet5 is not in your sample file this is just to show you four vlookup with regards to post#12 & 10 of Alkey & Pete

[Debraj Roy]

Check this.. one also..

http://www.excelforum.com/showthread...=1#post3405933

try to adapt according to your file..
if you face any problem let us know..

[vengatvj]

Hi vlady. And all, now i understand how to make multiple lookup. Thanks to all dear friends....

[Pete_UK]

In your first post in this thread you said "I know vlookup", which is why I kept my replies in a general format - I assumed that you would be able to substitute your VLOOKUP formulae in the appropriate places.

Pete

[vengatvj]

its ok pete.. anyway my problem solved, and i understand well about multiple vlookup.. if i need any information i will ask you pete_uk, i sent a friend request to you..

[Debraj Roy]

As per your last post.. i think the original problem has been solved..

please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.