Re: VLOOK UP
Tech-Archive recommends: Fix windows errors by optimizing your registry
Would it be possible to give some more detail on this formula PLEASE.
=vlookup(text(a1,"#"), matrix, column, false)
Pls. read the online help on the functions VLOOKUP and TEXT.
=text(a1,"#") makes '1 (=a text) out of 1 (which is a number)
vlookup searches in the first column your data table (matrix) if it can find
'1 and will return the value of the column you specify. "false" means that
it will search for an EXACT match (otherwise it would return the next best
match what you DO NOT WANT!)
arno
.
Relevant Pages
- RE: Formatting a lookup
... The values in the first column of table_array must be placed in ascending ... sort order; otherwise, VLOOKUP may not give the correct value. ... VLOOKUP will only find an exact match. ...
(microsoft.public.excel.worksheet.functions) - RE: Formatting a lookup
... The values in the first column of table_array must be placed in ascending ... sort order; otherwise, VLOOKUP may not give the correct value. ... VLOOKUP will only find an exact match. ...
(microsoft.public.excel.worksheet.functions) - Re: I need to know which function to use.
... Lookup_value The value to search in the first column of the table array ... Less than 1, VLOOKUP returns the #VALUE! ... exact match is not found, the next largest value that is less than ...
(microsoft.public.excel.worksheet.functions) - Re: vlookup and lookup
... The first column in the table are just manually entered. ... Valko" wrote: ... That means you want an exact match. ... Table.xlsx]Sheet1'!$A$1:$A$10000,'[Job Size Multipliers ...
(microsoft.public.excel.worksheet.functions) - Re: More then 7 IF functions?
... You can replace your formula with a much simpler VLOOKUP, ... First of all set up a two-column ... This takes the value in C4 and sees if there is an exact match in the ... first column of the table Y1:Z30 - if there is it then returns the ...
(microsoft.public.excel.worksheet.functions) |
|
