Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup
Hello,
I'm getting really frustrated with vlookup. I'm looking at a document that uses it a lot and I'm trying to figure out where it's getting these numbers. Can someone explain how vlookup works? Z |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
It depends.........VLOOKUPS can get pretty hairy........the basic version is:
=VLOOKUP(the cell contents you want to look up, the range of cells that makes up your table, the number of columns you want to step to the right to find the value, whether you want an exact match or not) If that don't do it for you, post back one of your troublesome formulas and someone will help further.......... Vaya con Dios, Chuck, CABGx3 "zahoulik" wrote: Hello, I'm getting really frustrated with vlookup. I'm looking at a document that uses it a lot and I'm trying to figure out where it's getting these numbers. Can someone explain how vlookup works? Z -- zahoulik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |