Re: VLOOKUP - avoiding left column rule
From: Bill Martin (wylie_at_earthKILLSPAMlink.net)
Date: 11/03/04
- Next message: cookie: "Formulas"
- Previous message: Don Guillett: "Re: Need to use countif but I have 2 condition"
- In reply to: grphillips: "VLOOKUP - avoiding left column rule"
- Next in thread: Dave Peterson: "Re: VLOOKUP - avoiding left column rule"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 3 Nov 2004 10:14:57 -0500
> Any ideas how to avoid the left hand side of the page rule with
> VLOOKUP, I the lookup value must always been the left foremost column.
> Any ideas how to avoid this by using a formula within a vlookup.
>
>
> Please illustrate clearly and explain reasons why it work?
I just use LOOKUP in those cases. This allows you to search within one
column of your sheet and then find the corresponding number in another column
with no restrictions requiring the left column. The HELP file in Excel will
explain its use.
For example: =LOOKUP($E$4,I4:I200,A4:A200) will search the "I" column and
then fetch the corresponding result from the "A" column.
Good luck...
Bill -- (Remove KILLSPAM from my address to use it)
- Next message: cookie: "Formulas"
- Previous message: Don Guillett: "Re: Need to use countif but I have 2 condition"
- In reply to: grphillips: "VLOOKUP - avoiding left column rule"
- Next in thread: Dave Peterson: "Re: VLOOKUP - avoiding left column rule"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
