L
Lenard
I will try and explain what i am trying accomplish.
Trying to create a function where the "New" sheet with no prices on it with
different styles of utensils 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, I managed to use a vlookup on another sheet named "Sold"
that
when I choose from the "Sold" sheet the style, it will show the "New" and
"Utensils" data is a match or not with "S" for match or "N" for non-match. So
when an item is sold, I use the "Sold" sheet vlookup but it also shows if the
"New" and "Utensils" sheets match or not on that data.
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
Trying to create a function where the "New" sheet with no prices on it with
different styles of utensils 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, I managed to use a vlookup on another sheet named "Sold"
that
when I choose from the "Sold" sheet the style, it will show the "New" and
"Utensils" data is a match or not with "S" for match or "N" for non-match. So
when an item is sold, I use the "Sold" sheet vlookup but it also shows if the
"New" and "Utensils" sheets match or not on that data.
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