3. How to use 2 numbers in a text string + 3rd number in the same string to determi...

How to use 2 numbers in a text string + 3rd number in the same string to determine which cell to retrieve

Sorry for not being more clear. I'll attempt to answer your questions in the order in which they were asked.

E12 is where I want the value from the table referenced from the Installation Kit pricing info table.

B3 is the cell that contains the data (user entry) that identifies which Installation Kit is necessary.

Code in B3 (CCXNNTT-#) is picked from a drop down list.

No, each Installation Kit is used by 2 different codes (for example, CCX64HO-6 Lamp and CCX64-6 Lamp share the same Installation Kit, and CCX36HO-4 Lamp shares the same Installation Kit with CCX36-4 Lamp). I can add each of the applicable codes to the Installation Kit table.

/r/excel Thread Parent
Previous
Next

Recently removed from /r/excel

Excel Solver either keeps changing the answer or gives the same wrong answer. How do you get rid of the blasted format painter icon that obscures text - Excel/Mac 16.72 - Microsoft 365 What’s the easiest way to share an excel document with Reddit? How do I set a character max and format? Calculate total number of years months and days from already calculated set of individual results displayed as years months and days. Dynamic Scheduling Based on Rotation and Start Day Is there a way to turn my date range in text form to a two-column number form date range? Is there any way to freeze the top row by default or otherwise save the state of frozen cells? Why is my rounding bugging? Vlookup issue with value that exists completing the excel exposure Complicated MOD function that possibly might just be algebra.. Comparing two workbooks for differences Microsoft Money for Excel released today How do I insert a number of blank rows between every row of data, and then copy each row down?

More Random Comments

CMV: Not accepting a lot of asylum seekers doesn't have to be inhumane or immoral Ouvy and his daugter mb guys she looked 10 in another pic she prolly like 5 or 6 Advice on my situation? (Trigger warning for those not supporting abortion) Trump supporter who protested against vaccinations dies of COVID-19 Rand Paul seeks “Criminal” Investigation of Dr. Fauci After Senate Tussle What Wolff actually mailed to the stewards came down to this. Mayor-President’s proposed fiscal recovery budget just released… A new take on Hill Giants Peterson Air Force Base, Schriever Air Force Base and Cheyenne Mountain Air Force Station to get new names Can someone more woke than me explain how they got the pronoun's wrong? Did you ever turn down callings as a TBM? "Being Black with anxiety is the worst because every anxious interaction you have gets vilified." CSGO — Valve announces Dreams & Nightmares, A $1,000,000 CS:GO Art Contest Popping confetti under high voltage lines Twitter lets literal Nazis thrive on their platform