Look up functions

G

Gabe

Does Excel have the ability to look for a value in a range of cells, then, if it finds that value, return the value in the adjacent cell? For example, I want Excel to look for the word "bus" in column A, and if it finds "bus" in cell A30, then return the value in cell B30.
 
A

AlfD

Hi!

It most certainly has.

Try Excel Help under HLOOKUP and VLOOKUP for starters.

Al
 
F

Fred Smith

You want Vlookup, as in:

=vlookup("bus",A:B,2,false)

The third parameter specifies the column number in the lookup range. The
fourth parameter says "find an exact match". Use True to find the closest
match, but the column must be in sort order to do so.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


Gabe said:
Does Excel have the ability to look for a value in a range of cells, then,
Click to expand...
if it finds that value, return the value in the adjacent cell? For example,
I want Excel to look for the word "bus" in column A, and if it finds "bus"
in cell A30, then return the value in cell B30.
 
Top