LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 103
Default Lookup table

hi,

I am using a lookup table to bring the value from one workshreet to another.
My lookup_value is slightly different than value_table_array. Below ae some
examples.

How can I match value to the table as they are the same customer?

Lookup Value Value_table_array

First American Title Co First American
Raytheon Company. Raytheon Co.
Charles River Lab Charles River
Endologix Endologix Inc
Sanford Health Sanford Health
Schering Schering Corporation.
TBC Parent TBC Parent Holding
Texas Health Resources Texas Health Resources
The Hertz Corp The Hertz


Dinesh
 
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
Table Lookup Andrew Mackenzie Excel Discussion (Misc queries) 4 September 3rd 09 03:13 PM
Lookup data in a variable table & retrieve data from a pivot table Shawna Excel Worksheet Functions 3 October 10th 08 11:11 PM
How do I lookup a corresponding value in another table Des Excel Worksheet Functions 2 November 7th 05 11:28 AM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
Lookup Table Ben Excel Worksheet Functions 7 November 30th 04 07:05 PM


All times are GMT +1. The time now is 12:49 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"