Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP question
In =VLOOKUP(A2,'C:\[Pricing.xls]Sheet1'!A:C,3,FALSE)*B2, what does
"A:C,3,FALSE" mean? |
#2
|
|||
|
|||
The False means that an exact match must be made between the lookup value
(A2) and the lookup range an error will be the result if there is no match. advantages of this are that when you must have an exact match you can force it. also the lookup table does not have to be sorted before it works. "Watercolor artist" wrote: In =VLOOKUP(A2,'C:\[Pricing.xls]Sheet1'!A:C,3,FALSE)*B2, what does "A:C,3,FALSE" mean? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
VLookup Question | Excel Worksheet Functions | |||
Vlookup Question | Excel Discussion (Misc queries) |