| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
