Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i saw this post sometime ago and cut it out for future use. yesterday i was
trying to test it out and the lookup solution doesn't work if B1 is blank. it returns #NA. the other two cells work. i know that one of the solutions had an if statement and that works but i am curious why the lookup doesn't work. thanks for your help. -- aprilshowers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change multiplier using letters | Excel Discussion (Misc queries) | |||
how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
change lower letters to upper letters | Excel Discussion (Misc queries) | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions |