LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Alex
 
Posts: n/a
Default vlookup question

I have one spreadsheet with a column of products and another spreadsheed with
the same products and prices.
I need to make links from the first sheet to the second one with the prices
to reflect them in the first sheet.
The list of products is sorted differently. This is why I'm going to use
VLOOKUP.

But, the problem is that in the first spreadsheet some products marked with
*, which make them slightly different from those, which should be find in
the second spreadsheet. As an example, BBB and *BBB.
How VLOOKUP could avoid this * to find the same product but without this sign.

Thanks


 
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 question KG Excel Discussion (Misc queries) 9 May 21st 05 07:12 PM
Attn: Dave P. Question re Pix Calls via Macro DocuMike Excel Discussion (Misc queries) 1 January 10th 05 01:38 AM
Vlookup Question Jeff Excel Discussion (Misc queries) 2 December 2nd 04 02:40 PM
Need help with modifying VLookUp Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM
Using Cell references in VLookUp JonWilson631 Excel Worksheet Functions 1 November 4th 04 02:49 AM


All times are GMT +1. The time now is 11:33 PM.

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"