Look for and Retrive Data
Use this instead.........
=IF(ISNA(VLOOKUP(C2,A:B,2,FALSE)),"",VLOOKUP(C2,A: B,2,FALSE))
Vaya con Dios,
Chuck, CABGx3
"CrimsonPlague29" wrote:
Thanks, works great, just one further question is there any way to not have
N/A show up in all the cells once I copy the function, would prefer a blank
cell??
"CLR" wrote:
Try this in D2...........
=VLOOKUP(C2,A:B,2,FALSE)
Vaya con Dios,
Chuck, CABGx3
"CrimsonPlague29" wrote:
Hello,
I have data as follows
Item A Item B Item C Item D
1 10
2 20
What I require is that when user enters info in Item C column that the
corresponding Item B appears in Item D column.
example: user enters 1 in Item C column want 10 to appear in Item D column
Please Advise
Thanks
|