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