I want a vlookup to see a number "A1"
look into a table and retrieve a cost. But if one isn't returned I would like it then to preform another lookup to a different field.
How would I do this?
Thanks,
I want a vlookup to see a number "A1"
look into a table and retrieve a cost. But if one isn't returned I would like it then to preform another lookup to a different field.
How would I do this?
Thanks,
you could use iferror(vlookup formula),other vlookup formula. something like =IFERROR(VLOOKUP(A2,C:C,1,FALSE),VLOOKUP(b2,d:d,1,FALSE) with your ranges
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks