Vlookups

[lgs1983]

Hi Guys,

Hopefully there is a answer to this and will try to explain as best as possible to give you an idea of what I'm after.

I want to try to vlookup over two sheets so if one sheet returns false or #n/a then for it to vlookup to another sheet and search that for the match.

Is this possible or do you require further information from me?

Thanks

LgS

 

[Sandeep Warrier]

One possible way.

Suppose you want to lookup the value in A2 in Sheet1 in the sheets 2 and 3, then

=IF(ISNUMBER(MATCH(A2,Sheet2!$A$2:$A$100,0)),
          VLOOKUP(A2,Sheet2!$A$2:$D$100,3,0),
              VLOOKUP(A2,Sheet3!$A$2:$D$100,3,0))

Assuming your table range in sheet2 and 3 is columns A to D and 100 rows.

 

[lgs1983]

Sandeep, thanks for your response.

What does this part of the script need to look at?

IF(ISNUMBER(MATCH(A2,Sheet2!$A$2:$A$100,0))