Forum Discussion
Solved
Excel if formula
Hi all, So I need to create formulae that will check the entire worksheet. So for example I need to be able to input all my product names and then have the stock codes generate automatically. So if "...
- Hi Melissa,
Sounds a bit like you need a VLOOKUP formula, but when you say check the entire worksheet do you mean check a column in a worksheet?
Can you attach a small example file of what you mean please.
Thanks
Hi Melissa!
All you need to do is to enter the "Product Name" and "Stock Codes" in two columns respectively. Make sure that the product name should be unique.
then you can use "Vlookup" function to see the same result any where in your workbook.
thank you.
All you need to do is to enter the "Product Name" and "Stock Codes" in two columns respectively. Make sure that the product name should be unique.
then you can use "Vlookup" function to see the same result any where in your workbook.
thank you.