Excel Experts - Need Help

[quakeworld]

Hi.

I'm trying to come up with a simpler formula for doing a vlookup across multiple worksheets. The one I found was this:

=IF(ISNA(VLOOKUP(A2,[Sheet2]Sheet1!$A:$H,2,0)),IF(ISNA(VLOOKUP(A2,[Sheet2]Sheet1!$A:$H,2,0)),VLOOKUP(A2,[Sheet2]Sheet1!$A:$H,2,0)),VLOOKUP(A2,[Sheet2]Sheet1!$A:$H,2,0))



Is there a more streamlined way of doing this?

 

[mayest]

There probably is an easier way, but without seeing your worksheets it is hard to know. A couple of things:

1) If you are using Excel 2007, there is a new IfError function that would likely simplify things. You could get rid of the ISNA and the one of the VLookups.
2) Sometimes using Index with Match can be simpler, but usually not. In any case, you might look at those functions.