View Full Version : Solved: Vlookup with an Index & Match formula
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?
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.
Thanks, that's one large formula.
Thanks again...
JimS
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.