Display text based on content of 3 cells

Hi there,
What you wrote does not compute in my mind. Your example does not even make sense. How about using a better example and posting what you want the final outcome to be. Right now it sounds like you want you can just =CONCATENATE(A1,D1,F1,H1)

Thanks.

The content of Part#, Description and Equipment doesn't change. So I want a formula that will match the content of A, B and C in the work book and automatically fill in the text of D based on the first 3 cells.

Here are two possible solutions - they do the same thing but you may find one more user friendly than the other depending on your oveall needs.

The formula in D3 is a VLOOKUP referenced to the PartNum Table in the VLOOKUP tab. Another possible solution is the Named Constant "PN" (stands for 'part number'). It's a LOOKUP formula using the full part number (rather than only the first 3 characters) in column A to return the appropriate result. You'll find the PN formula in the Name Manager.

Hope this is something you can use...

Hi Steve,
The VLOOKUP looks the most promising here. Is it possible to have the VLOOKUP use 3 cells instead of the one? This issue that I have is that all 3 cells work together to create a unique result (part#, description, and equipment). If any of them are missing from the VLOOKUP then the result will be wrong. Thanks for the help.

try this one
=IF(COUNTIF(A$2:A2;A2)=1;SUMPRODUCT((1/COUNTIF($A$2:$A2;A$2:A2)))&"F";INDEX(E$1:E1;MATCH($A2;$A$1:$A1;0)))

copy down

Sean,
Thanks for you help. This is doing exactly what I need it to do. One last question. How would I set the code to populate Cell 4 and Cell 5 on occasion?

If Sheet1.Cells(rowNo, 1) Like "ABC123" And Sheet1.Cells(rowNo, 2) Like "5 gal bucket" And Sheet1.Cells(rowNo, 3) Like "Car" Then
Sheet1.Cells(rowNo, 4).Value = "1F"

How can I tell this code to also fill rowNo, 5 with the same information? Can it be added with this same line of code, or would I need a separate line of code with rowNo, 5?

Hi Sean,
Everything you have posted works great. I have one small issue left here so I hope you can help me out again. I have my macro saved in personal.xls. When I open a workbook and try to use the macro, it does nothing. If I copy the the macro to the workbook, it works. Shouldn't the macro work from the personal workbook on another workbook without copying it over?