Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP
Hi
I have a spreadsheet which I need to download from a web site into another spreadsheet daily. I currently use VLOOKUP and the cell references to look up the function, but the data in the spreadsheet which is data belonging to various people often ends up being in a different column, is it possible for VLOOKUP to look for a person's name as well as the cells the data is stored in? Thanks in advance Kath |
#2
|
|||
|
|||
use =match to find your column number
-- hope this helps Paul "kathleen.smith10" wrote: Hi I have a spreadsheet which I need to download from a web site into another spreadsheet daily. I currently use VLOOKUP and the cell references to look up the function, but the data in the spreadsheet which is data belonging to various people often ends up being in a different column, is it possible for VLOOKUP to look for a person's name as well as the cells the data is stored in? Thanks in advance Kath |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |