vlookup

  • Thread starter Thread starter Scrappy
  • Start date Start date
S

Scrappy

I have an excel sheet with four columns:

customer_id
customer1
customer#
customer2

All values in customer 2 (and more) appear in customer1
customer_id is blank

I want to compare customer2 to customer1 and if the value is found then I
want to return the corresponding value from customer# to customer_id. I
think this is a vlookup, maybe with an IF as well. Any help would be
appreciated! Thanks!

Darren
MCP
 
Scrappy said:
I have an excel sheet with four columns:

customer_id
customer1
customer#
customer2

All values in customer 2 (and more) appear in customer1
customer_id is blank

I want to compare customer2 to customer1 and if the value is found then I
want to return the corresponding value from customer# to customer_id. I
think this is a vlookup, maybe with an IF as well. Any help would be
appreciated! Thanks!

Darren
MCP
Click to expand...
Assume CustID is Column A, Cust1 is B, CustNo is C, Cust 2 is D:

=if(B2=VLOOKUP(B2,D2:D100,1),C2,"")
 
Thanks for the reply, but this seems to be returning the value for the row
that the function is in, hence the ),C2,""). I need it to return the value
from the row that it found the match!
 
Back
Top