Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Vlookup to change a column

Hello, I have a column of customers (A) and a column of Part #s (B).
I also have a short column of part #s (C). If a part in (B) is found in (C),
I want it to change to a totally different customer, say it is in (D). If it
doesn't match I want it to stay the same.
Thanks for looking.
Mike

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,069
Default Vlookup to change a column

It sounds like you want to put a Vlookup in column A with a possible result
being the value that already was in column A. You can't have a value and a
formula in the same cell. But you could do this:

1. Insert a new column A (a new column to the left of A).
2. In A1, enter the following formula:
=IF(ISERROR(VLOOKUP(C1,D:E,2,FALSE)),B1,VLOOKUP(C1 ,D:E,2,FALSE))
3. Copy A1 down as far as needed.

Hope this helps,

Hutch

"Cube Farmer" wrote:

Hello, I have a column of customers (A) and a column of Part #s (B).
I also have a short column of part #s (C). If a part in (B) is found in (C),
I want it to change to a totally different customer, say it is in (D). If it
doesn't match I want it to stay the same.
Thanks for looking.
Mike

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 698
Default Vlookup to change a column

Hi Mike,

I believe I figured out your lookup but had to move the long list of
customers to the right of the long-list of part numbers.

=IF(ISNA(VLOOKUP(F15,D15:E19,2,0)),VLOOKUP(F15,B15 :C24,2,0),VLOOKUP(F15,D15:E19,2,0))

Where F15 is the part number to look up.
D15:E19 is the short part# list and different customers.
B15:C24 is the long part# and customer list.

So, if the part# in F15 is found in the first lookup you get a different
customer from the short list.
If the part# in F15 is not found in the first lookup, it returns ISNA and
the lookup goes the long list.

I can send my sample work sheet if you want to help you figure it out.

HTH
Regards,
Howard

"Cube Farmer" wrote in message
...
Hello, I have a column of customers (A) and a column of Part #s (B).
I also have a short column of part #s (C). If a part in (B) is found in
(C),
I want it to change to a totally different customer, say it is in (D). If
it
doesn't match I want it to stay the same.
Thanks for looking.
Mike



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Data in two seperate Spreadsheets Padraig Excel Worksheet Functions 6 June 28th 06 03:05 PM
Running total w/2 columns - Excel Anna / Ideal Excel Worksheet Functions 14 August 10th 05 04:28 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 08:25 PM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"