VLookup - can I set my formula to fill in date if item isn't i
Here is my formula:
=IF(B11="","",VLOOKUP(B11,$IO$138:$IT$20454,4,0))
and if B11 isn't a product in my lookup table, I want it to say "hardware"
instead of #NA.
"T. Valko" wrote:
What default value would you like?
One way is to leave the cell blank if the lookup value isn't found:
=IF(ISNA(VLOOKUP(..........)),"",VLOOKUP(......... .))
Just replace the "" with whatever default value you want. Just remember that
a TEXT value needs to be enclosed in quotes: "text" and a numeric value
doesn't: 0.
Biff
"NANGO" wrote in message
...
I have quote spreadsheet in which sale rep can fill in a part number and
the
description, price and type of item it is fills in automatically.
My question is, if they part number isn't in the vlookup table, I want a
default answer to fill in the type column instead of #N/A.
Is that possible, and if so, how would I do it?
Thanks
|