IF & VLOOKUP integrated !

[sonu1975]

Hi,

In sheet "IF & Vlookup" I want a formula where I want it to get the value (first) from sheet "Nr 1" and if it cannot find it in sheet "Nr 1" then it has to get the value from sheet "Nr 2" and if it cannot find the value in both sheets then it should be 0.

Appreciate all the help !

S

[etaf]

try
=IF(ISERROR(INDEX('Nr 2'!C:C, MATCH('IF & Vlookup'!A2,'Nr 2'!B:B,0))), IF(ISERROR(INDEX('Nr 1'!C:C, MATCH('IF & Vlookup'!A2,'Nr 1'!B:B,0))), "not Found", INDEX('Nr 1'!C:C, MATCH('IF & Vlookup'!A2,'Nr 1'!B:B,0))),INDEX('Nr 2'!C:C, MATCH('IF & Vlookup'!A2,'Nr 2'!B:B,0)))

you can changed the

"not found" to 0 with no ""
to get a zero

just wanted to make sure it was not found rather than returning a zero in error - as some codes have zero

[Pete_UK]

You can use this formula:

=IFERROR(VLOOKUP(A2,'Nr 1'!B:C,2,0),IFERROR(VLOOKUP(A2,'Nr 2'!B:C,2,0),0))

You might need to use semicolons ( ; ) instead of commas ( , ).

Hope this helps.

Pete

[martindwilson]

you have posted an xlsx which presupposes you have excel 2007 or later so yo can use iferror
=IFERROR(IFERROR(VLOOKUP($A2,'Nr 1'!$B$3:$C$1000,2,FALSE),VLOOKUP($A2,'Nr 2'!$B$3:$C$1000,2,FALSE)),0)