lookup tables

[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

 

[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))

 

[joeldsmt]

thanks...

that might just be what i am looking for.

J