Trying to match two cells to obtain $ dollar value from a third cell

[D.G. DeGennaro]

Fellow Excelers,

I created a alpha-numeric generator in excel. It takes drop down inputs and builds the string based upon the inputs with each character representing a material or color. An alpha-numeric string example looks like this: 1A41A3CSA1856 and it resides in cell F6 on my spreadsheet. Now I want it to match the same alpha-numeric string (1A41A3CSA1856) that resides in Z12 so any time the two cells match, it would bring up cell Z8 that contains a price value of $7,797. idea being, when I generate an alpha numeric string, there would be the same existing string to match and bring up the associated price. Really looking for help building a VBA that woulddo it.

[MrShorty]

Are you required to use VBA? I'm not sure I understand the details, but it feels like a basic lookup task, for which Excel has some very workable lookup functions:

1) A MATCH() function will find the alpha-numeric string in a vector/range MATCH(F6,$A$12:$AZ$12,0) will tell you what column/position your string is found in.
2) An INDEX() function will return the corresponding value from a different column/row/vector =INDEX($A$8:$AZ$8,MATCH(...)) will search row 12 for the string in F6, return the column number, then return the corresponding value from row 8.
(help files for these functions are in the lookup and reference functions here: https://support.microsoft.com/en-us/...rs=en-us&ad=us

If you are required to use VBA for this, these functions (as well as the .cells() property) are available in VBA for performing the same sequence of operations in VBA. It really depends on what the VBA is needing to do (that the regular worksheet functions are not doing).

[D.G. DeGennaro]

I've tried those functions and perhaps not correctly inputting them. I figure a pictures is worth a thousand words so I will to upload a picture to give a better idea. I'm only trying to match two cells to obtain the value
from a third cell. So when the number from P9 matches (P9 isnt a constant value, it will change depending upon the drop down boxes) Z12, I would get Z8 as a price in U9

Untitled.jpg

[D.G. DeGennaro]

Over thought it=if(f6=Z12,Z8,0) But what I appreciate is the help form you folks. Trust me, as I continue down this excel path I may hopefully ask less sillier questions.