give value of next column

[erables40]

Hi I am trying to use the find or lookup function to give me the value
of the adjacent cell.
Ex I want to look in a worksheet for the word car, if found I want to
get the value of the cell next to it on the right.
TIA

 

[Chip Pearson]

The VLOOKUP function is most likely what you are looking for. For example,

=VLOOKUP(A1,D1:F10,3,FALSE)

In this formula, the value to look for is in A1. The range to search is
D1:F10. VLOOKUP will scan down the first column of D1:F10 looking for a
match against A1. If a match is found, VLOOKUP returns the value in the 3rd
column to the right. The FALSE parameter indicates that only an exact match
should be considered successful. If this is FALSE, the data in D1:F10 can be
in any order. If this is TRUE, the data in D110 must be in sorted order,
and VLOOKUP will match the largest value in D110 that is less than or
equal to A1.

If the value cannot be matched, the function returns #N/A.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[erables40]

The VLOOKUP function is most likely what you are looking for. For example,

=VLOOKUP(A1,D1:F10,3,FALSE)

In this formula, the value to look for is in A1. The range to search is
D1:F10. VLOOKUP will scan down the first column of D1:F10 looking for a
match against A1. If a match is found, VLOOKUP returns the value in the 3rd
column to the right. The FALSE parameter indicates that only an exact match
should be considered successful. If this is FALSE, the data in D1:F10 can be
in any order. If this is TRUE, the data in D110 must be in sorted order,
and VLOOKUP will match the largest value in D110 that is less than or
equal to A1.

If the value cannot be matched, the function returns #N/A.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)

Work

 

[erables40]

Work

works great if value looked for is in column A but if in column B or C
then I get an N/A. How can I make it so it can look everywhere?