Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display TRUE / FALSE Instead Of 1 / 0 | Excel Discussion (Misc queries) | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
function help-keeping data from true when false | Excel Worksheet Functions | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Displaying data based on a TRUE/FALSE value in a cell | Excel Discussion (Misc queries) |