help with formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I still cannot figure out how to write the formula for a vlookup. I need it to take a customer number and automatically figure the customer name. ex Renee's Production is customer #d854, how can i formulate so that when i type in d854 in the customer number column, the next column will automatically bring up Renee's Production? I'm new to this formula stuff. I've looked at the vlookup worksheet function page, but I still can't get it right.
 
=VLOOKUP(D854,H1:M100,2,FALSE)

where H1:M100 holds the number name table.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

renee said:
I still cannot figure out how to write the formula for a vlookup. I need
Click to expand...
it to take a customer number and automatically figure the customer name. ex
Renee's Production is customer #d854, how can i formulate so that when i
type in d854 in the customer number column, the next column will
automatically bring up Renee's Production? I'm new to this formula stuff.
I've looked at the vlookup worksheet function page, but I still can't get it
right.
 
Hi
if you like email me an example file and I'll set up a VLOOKUP formula
for you. Just describbe what you're trying to achieve
 
I believe the "d854" in the OP was the actual customer number, not a cell reference. So to clarrify a bit

=vlookup(A2,D1:E100,2,FALSE

with a2 holding the customer number that you will input
column d and e holding all the customer number and names respectively

What the function is doing is taking the first argument (the value in A2) and looking for it in the first column of the second argument (D1:E100). Upon finding it it returns the coresponding value in the 2nd column (third argument) of that range. The last argument is telling Excel to find an exact match

----- Bob Phillips wrote: ----

=VLOOKUP(D854,H1:M100,2,FALSE

where H1:M100 holds the number name table

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

renee said:
I still cannot figure out how to write the formula for a vlookup. I nee
Click to expand...
it to take a customer number and automatically figure the customer name. e
Renee's Production is customer #d854, how can i formulate so that when
type in d854 in the customer number column, the next column wil
automatically bring up Renee's Production? I'm new to this formula stuff
I've looked at the vlookup worksheet function page, but I still can't get i
right
 
Back
Top