Look for and Retrive Data
 

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

Look for and Retrive Data
 

You can use =vlookup() to do what you want.

Just a suggestion: I'd move the table to a different worksheet to keep it
safe(r).

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())

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

--

Dave Peterson

Look for and Retrive Data
 

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

Look for and Retrive Data
 

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

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