ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   match data in 2 sheets then display true/false from vlkup (https://www.excelbanter.com/excel-worksheet-functions/160689-match-data-2-sheets-then-display-true-false-vlkup.html)

Lenard

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



All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com