Formula help

  • Thread starter Thread starter Paul
  • Start date Start date
P

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.
 
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.
Click to expand...

Take a look at HELP for VLOOKUP.

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