| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another lookup question
I got great help the last time, and here's an easier question:
I have 2 sheets, sheet1 and sheet2, both are like a database, with the first column containing the ID Key that links them. I need sheet1:column B to refence column F on sheet2, using the relationship from sheet1:A to sheet2:A thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Another lookup question
On Jan 8, 3:56 pm, Southern at Heart
wrote: I got great help the last time, and here's an easier question: I have 2 sheets, sheet1 and sheet2, both are like a database, with the first column containing the ID Key that links them. I need sheet1:column B to refence column F on sheet2, using the relationship from sheet1:A to sheet2:A thanks! =VLOOKUP(A2,Sheet2!$A$2:$F$1000,6) Assuming there is a header row in both sheets and that you have 999 rows of data in sheet 2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question regarding lookup | Excel Discussion (Misc queries) | |||
| Lookup question | Excel Worksheet Functions | |||
| Lookup question | Excel Discussion (Misc queries) | |||
| Lookup question | Excel Discussion (Misc queries) | |||
| Lookup Question | Excel Worksheet Functions | |||
Linear Mode
