agwalsh
asked on
Combining match and vlookup???
hi I have a list of values so I want a formula that if someone picks - for example in an A frame, Standard spec, clear span and which has a measurement close to one of the entries in the width column e.g. if the width was 8 (between 6.51 and 9.16) the answer would be .32 in the weight column. (G3). I've been experimenting with index and vlookup...but I'm having a brain freeze...
EE-combining-cells.xlsx
EE-combining-cells.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Did exactly what was required...thank you :-)
ok great and glad I could help
gowflow
gowflow
ASKER