lookup tables

J

joeldsmt

can i have two look up tables. one that has old prices and part number
and one that has price revisions and additional parts?

If so, how do i do this so that on my main page i enter a part numbe
and the newest data is entered?


thank you so much in advance.

J
 
D

Dave Peterson

Do one vlookup against the revision table. If it returns an error, then do
another vlookup against the older table.

=if(iserror(vlookup(revisiontablestuff)),
vlookup(oldtablestuff),vlookup(revisiontablestuff))
 
Top