Multiple IF ISERROR and VLOOKUPs

[Teddy15]

I'm trying to write a formula that is looking up an ID number in 4 different tabs and returning the value of a data point in whichever tab that ID number is in. Says i have too many arguments.

Tabs A, B, C, and D
Person #1234



IF(ISERROR(VLOOKUP(A3,A!A:A,1,0)),IF(ISERROR(VLOOKUP(A3,B!B:B,1,0)),IF(ISERROR(VLOOKUP(A3,C!B:B,1,0)),IF(ISERROR(VLOOKUP(A3,D!B:B,1,0)),"",VLOOKUP(A3,D!B:AI,4,0)),vlookup(A3,C!B:AI,4,0)),vlookup(A3,B!B:AI,4,0),vlookup(A3,A!A:A,1,0))

 

[Oeldere]

why not add all data in 1 worksheet.

it makes it a lot easier to anlyse the data (e.g. with a pivot table).

 

[Teddy15]

i know but they are 4 different data sets that should be kept separate. is there any way to do this?

 

[Oeldere]

copy => paste (values) the data in 1 worksheet.

 

[bosco_yip]

Try this :

=LOOKUP(9.99E+307,CHOOSE({1,2,3,4,5},0,VLOOKUP(A3,D!B:AI,4,0),VLOOKUP(A3,'C'!B:AI,4,0),VLOOKUP(A3,B!B:AI,4,0),VLOOKUP(A3,A!A:A,1,0)))

Edit : will return 0 if not find.

Regards