L
LB79
Is there a way i can do the following using VLOOKUP?
Cells A1:A20 contain 3 letter codes
Cell C5 conatains code ANR
In cell C6 i want to use VLOOKUP to check if the value of C5 (ANR) i
listed in range A1:A20.
If the value (ANR) is there i want it to be a blank cell. If the valu
(ANR) is not there i want it to show the value of C5 (ANR).
Thank
Cells A1:A20 contain 3 letter codes
Cell C5 conatains code ANR
In cell C6 i want to use VLOOKUP to check if the value of C5 (ANR) i
listed in range A1:A20.
If the value (ANR) is there i want it to be a blank cell. If the valu
(ANR) is not there i want it to show the value of C5 (ANR).
Thank