Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing a cell where lookup value is not on same row
Hi,
I need some help... Here is my data: _____________________________________________ A B C D 1 ID Number Name Hours 2 10153 Joe 8 3 8 4 8 5 Total 24 6 7 10219 Bob 5 8 5 9 Total 10 10 11 10569 Tim 10 12 8 13 8 14 5 15 Total 31 ___________________________________________ Basically, I want to copy the ID number, Name, and Total onto a separate worksheet minimizing the need for manual data entry e.g. 10153 Joe 24 10569 Tim 31 etc. Basically, I can copy the ID number onto the new worksheet and use a vlookup to get the name. But I'm having difficultly referencing the Total since it's not on the name row as the ID and Name. Any suggestions? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup referencing ranges that are variable | Excel Worksheet Functions | |||
Help! Need to lookup referencing 2 variables | Excel Worksheet Functions | |||
Referencing cell text in a lookup | Excel Discussion (Misc queries) | |||
Referencing 3 values for a lookup | Excel Worksheet Functions | |||
What is the syntax for referencing another sheet with 'lookup' | Excel Worksheet Functions |