unfortunaltely, the best metod I know of is
=if(iserror(Vlookup(ref,GMP!range,2,0)),if(iserror (Vlookup(ref,FMP!range,2,0)),if(iserror(...)
...,Vlookup(ref,FMP!range,2,0),Vlookup(ref,GMP!ran ge,2,0))))
"Hirsch" wrote:
Is there a formula to incorporate a vlookup scanning multiple tabs.
i.e.
Total Tab will scan "GMP" "GMT" "FMP" & "TRN"
returning #n/a for the missing information and the first line item found on
the rest.
Thanks in advance.
|