| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula
Sheet 1 is my Form and Sheet 2 is my Clients with diagnoses (in next cell)
I pull clients over to my form by the use of a drop box. Now, in another cell in sheet 1, I want that cell to recognize the client's cell reference in Sheet 2 as B1,B2, etc..... and pull its diagnosis over into the new cell. Does this make sense? I need this for all 57 clients. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need formula
vlookup formula will do this, check the help screen for details on how to use
it "vferg" wrote: Sheet 1 is my Form and Sheet 2 is my Clients with diagnoses (in next cell) I pull clients over to my form by the use of a drop box. Now, in another cell in sheet 1, I want that cell to recognize the client's cell reference in Sheet 2 as B1,B2, etc..... and pull its diagnosis over into the new cell. Does this make sense? I need this for all 57 clients. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
