LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 318
Default vlookup to a word in a cell

Hi Scenario 2 workbooks with the same information . I need to do a
vlookup ( I think) to get the total number of orders for the company .
example workbook one has the name of the company as Arizona Chemicals Inc
THe other workbook has the name of the Company as Arizona Laboratories (they
are the same company) How can I do a vlookup so that these two match .
Maybe vlookup is the wrong function? All the names of the companies do not
exactly match in the two workbooks. thanks in advance Excel 2003
 
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
VLOOKUP IF Cell Contains a Word within Text DAWN Excel Discussion (Misc queries) 3 April 5th 23 01:07 PM
make cell equal a word if a data validation cell has a word in it Robzz Excel Discussion (Misc queries) 1 February 6th 09 06:20 PM
VLOOKUP IN WORD Sal Excel Discussion (Misc queries) 2 August 30th 08 08:04 AM
Vlookup to word Colin Excel Discussion (Misc queries) 0 March 2nd 06 04:36 PM
Vlookup for part of a word jenhow Excel Worksheet Functions 7 April 29th 05 10:22 PM


All times are GMT +1. The time now is 03:00 AM.

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

About Us

"It's about Microsoft Excel"