Look up functions

[Guest]

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.

 

[AlfD]

Hi!

It most certainly has.

Try Excel Help under HLOOKUP and VLOOKUP for starters.

Al

 

[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

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.