PDA

View Full Version : Solved: Vlookup with an Index & Match formula



JimS
04-12-2011, 08:46 AM
I need to grab the value from a table based on how another cell aligns/matches to its values.

The attachment shows what I’m trying to do.

Thanks for any help...

JimS

BrianMH
04-12-2011, 10:10 AM
Do you need to be able to add values to the color codes or is there always just going to be the 4? Are you happy with a UDF?

nepotist
04-12-2011, 10:11 AM
Is the purpose of this to finally color the cells or does color code actually important?if it is just the color that is important then did you try conditional formatting?

JimS
04-12-2011, 12:20 PM
No, I need to value from the Table, it's not for Conditional Formatting.

shrivallabha
04-12-2011, 10:36 PM
I've tried this with Named Range as the normal VLOOKUP and MATCH don't work if the LOOKUP ARRAY is on the left side. The table 'A7:B18' is now a named Range. The formula is built only for this case, it may become unwieldy for more cases.

I am attaching the workbook and there's a bit of doubt as Cases seem to change as Lower Limit<Value=>Upper Limit. I've marked the case 2 doubt in the worksheet.

JimS
04-13-2011, 10:50 AM
Thanks, that's one large formula.

Thanks again...

JimS