Formula help

[Paul]

I have customer numbers listed in column H and customer names listed in
column I.
I would like a formula in cell B6 that returns the corresponding customer
name when a customer number is entered into cell A6.

 

[Ron Rosenfeld]

I have customer numbers listed in column H and customer names listed in
column I.
I would like a formula in cell B6 that returns the corresponding customer
name when a customer number is entered into cell A6.

Take a look at HELP for VLOOKUP.

You will need to set range_lookup argument to TRUE
--ron