View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lenard Lenard is offline
external usenet poster
 
Posts: 2
Default match data in 2 sheets then display true/false from vlkup

I will try and explain what i am trying accomplish.

Trying to create a function where the "New" sheet (no cost$) with different
styles of utensils on it need to match the master "Utensils" sheet (with the
cost$) with the same style info but many more styles. Not all styles are on
the "New" sheet but need to match the ones in the "Utensils" sheet. The "New"
sheet is always updated of course with more or less new styles. How to match
the sheets?

The final problem is I require to show on another sheet named "Sold" that
uses vlookup from the master "Utensils" sheet to display the "New" and
"Utensils" data is a match or not with "S" for match or "N" for non-match.

Appreciate your help.
Layout of sheets:
eg. New sheet
col A |
style |

eg. Master Utensils sheet
col A | B...
style | Cost$

eg. Sold Sheet
col B | C | D
Style | Cost$ | Match S or N