| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup when data is not all in same row
I have a spreadsheet that outputs with a sales person name in A1 but the info
that I need from that name (using Vlookup) is in B6. The next sales persons name is in C1, info in D6 and so on. Currently I'm opening the spreadsheet and inserting a cell in the first row to drop A1 to B1. What I would like is a formula with Vlookup that will pull the info from B6 if it finds a match in A1. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| vlookup with data on more than one sheet | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
