jillianleigh
New Member
- Joined
- Jan 25, 2022
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
I have this formula I'm using to lookup style numbers from a table on another sheet (called Items) and input the description.
My original formula was "=IF(F3="","",VLOOKUP(F3,Items!A:D,2,FALSE))"
This worked great in that it removed the #N/A message if the cell was left blank and it looked up the items and inputted the item description.
The problem was that on style numbers that were only numbers (not letters) - it would result in a error. It messed up thinking when numbers were in number format.
So I used this formula to fix that issue:
=IFERROR(VLOOKUP(F3,Items!A:D,2,FALSE),VLOOKUP(TEXT(F3,0),Items!A:D,2,FALSE))
If an error happens, it converts the number to text so that the lookup function will find it. It works!
However - I don't know how to put back the function for it to not display #N/A when the cell is blank. It keeps saying there's two many arguments. Help!
My original formula was "=IF(F3="","",VLOOKUP(F3,Items!A:D,2,FALSE))"
This worked great in that it removed the #N/A message if the cell was left blank and it looked up the items and inputted the item description.
The problem was that on style numbers that were only numbers (not letters) - it would result in a error. It messed up thinking when numbers were in number format.
So I used this formula to fix that issue:
=IFERROR(VLOOKUP(F3,Items!A:D,2,FALSE),VLOOKUP(TEXT(F3,0),Items!A:D,2,FALSE))
If an error happens, it converts the number to text so that the lookup function will find it. It works!
However - I don't know how to put back the function for it to not display #N/A when the cell is blank. It keeps saying there's two many arguments. Help!