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 - 05 Mar 2008 14:44 GMT
>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