AXISHK
asked on
vlookup in Excel
=IFERROR(VLOOKUP(G1,'#Outp ut'!A1:H69 8, 8,FALSE), "")
The link above can prevent N/A from display if vlookup can match a record. However, if it match a record with blank field, the retrieved column will be shown as 0. Is it possible to let it show blank instead of 0?
Tks
The link above can prevent N/A from display if vlookup can match a record. However, if it match a record with blank field, the retrieved column will be shown as 0. Is it possible to let it show blank instead of 0?
Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's a cool trick, Patrick! I hadn't seen that before.
:)
ASKER
Tks