Formula with Concantenate

Hi,

To me this is a little complicated, hopefully to someone here it's not.

I'm trying to do a VLOOKUP on a couple of named instances. The first formula works, because I just put the named instance in there. I'm trying to look at the Manufacturer cell, and concatenate the manufacture name with the word Calc so I can use the named instances I created (CiscoCalc, DellCalc, HPCalc, etc) dynamically not statically. I'm getting a #Value error in the cell with the formula below. Any ideas?

Thanks

=IF(OR(N2="",K2="",L2=""),0,VLOOKUP([@Model],CiscoCalc),2,FALSE))

=IF(OR(N2="",K2="",L2=""),0,VLOOKUP([@Model],CONCATENATE([@Manufacturer],"Calc"),2,FALSE))

[QUOTE=Norie;3134231]Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Here's the sheet. The top row doesn't work, the bottom does

GeneSpreadsheet.xlsm

Originally Posted by Ace_XL

Try

Please Login or Register  to view this content.

That did it!!!! Thanks