Vlookip

[Ashish Batham]

I have two files say Book1 & Book2.
These files have some details

I have 03rd file say Book3, where i have to do vlookup, using Book1 & Book2 files

Half data is in Book1 & remaining half in Book2

Can I have to do a vlookup to get data from Book1 & if not found on Book1 formula will search for details in Book2

Attached are the sample files for your reference

 

[oldchippy]

Hi Ashish,

Take a look here

http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705

 

[ThrottleWorks]

@Ashish Batham , I think this can be done with the combination of Vlookup and iserror, not sure.

If you could try, else I will try and upload if successful.

P.S. - Could you please check this formula.
Formula is in range B2 of Book1, other open files are Book2 & Book3.

Please let me know if you face any issues.

"=IFERROR(VLOOKUP(A1,[Book2]Sheet1!$A:$B,2,0),VLOOKUP(A1,[Book3]Sheet1!$A:$B,2,0))"

 

[Aurelie]

Hi Ashish,

Yes, you can achieve this with a IFERROR formula:

=IFERROR(VLOOKUP(lookupvalue;tableBook1;col_index_num;FALSE);VLOOKUP(lookupvalue;tableBook2;col_index_num;FALSE))

This formula checks if there is something in the first table and if yes gives the looked up value, if not, looks up in the second table.

Does it work for you?

 

[Aurelie]

@ThrottleWorks

It MUST be the best solution in this case