Forum Discussion
Solved
help with a formula - i think vlookup and if?
Hi, Im hoping someone could please help me with a formula that I am struggling with. I have two sheets in the file. One file is the main page that is used and the other page has the data. The main...
- Thank you so much I should have posted days ago :).
See if you can finish this off for the rest of your "Ship To" codes. I made some modifications to the data table in order to accommodate the variability of weights when using the "Range lookup" aspect of VLOOKUP. And I use FILTER to, in effect, create a subset of the data table based on the "Ship to" code itself.
Here's the basic formula, a VLOOKUP using an array produced by FILTER
=VLOOKUP(C2,FILTER(Table1[[WEIGHT]:[WHAT CODE]],Table1[SHIP TO]='FRONT PAGE'!B2),2,1)If you're not familiar with FILTER, here's a helpful reference.
Thank you so much I should have posted days ago :).