Dear Admin,
I am attached stock with for your ref. I could not able to use vlookup formula. Pls help
IF i enter the material code, material description should appread.
Pls help
Regard,
SUN
Dear Admin,
I am attached stock with for your ref. I could not able to use vlookup formula. Pls help
IF i enter the material code, material description should appread.
Pls help
Regard,
SUN
1. Change your cell's format to General instead of text, then enter next formula =IF(ISNA(VLOOKUP(A5,Item!$A$3:$B$65536,2,FALSE)),"",VLOOKUP(A5,Item!$A$3:$B$65536,2,FALSE))
( there was a mistake in the second vlookup you used)
If there is a formula in the cell, after changing format hit F2 and enter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks