Excel Vlookup Multiple Formulas in one field?

**rasp13** · 02-01-2013, 04:16 PM

On sheet 1 I am trying to set up to where the user can input 1 of 4 different type of possible error codes and beneath that the information fields will fill in.
I already have on a 3rd sheet my table set up. I've already set up a working VLOOKUP for the 1st possible error message in each of the information fields. Now I'm confused on how to incorporate the other three possible error input fields to utilize the same information fields below.

Is there a way to set up the VLOOKUP to search for text in the four error message fields and when it finds one to complete the search? Or can you enter multiple VLOOKUP formulas in the same field?
I hope this makes more sense reading than it did typing.

**martindwilson** · 02-01-2013, 04:47 PM

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

**rasp13** · 02-01-2013, 05:03 PM

What I'm trying to do is which ever of the yellow filled codes they know will fill out the information underneath it. It's a project for work so I had to change all the real information.

**rasp13** · 02-01-2013, 09:32 PM

bump or refresh.

**martindwilson** · 02-02-2013, 07:15 AM

took a bit of time to reformat layout (and i had to sleep lol)
try this
wrap the whole formula in iferror if you want to hid #n/a when cells blank
=iferror(the long formula,"")