Lookup value in workseet 2, if exists specific cell, insert different text in Worksheet 1

[benicio]

I am attempting to enter a formula that, while working in Worksheet 1, will look at a data set in worksheet 2 for a specific set of text within a specific column, and if existing, will insert a different set of text into a specfic cell in worksheet 1.

Example:

Worksheet 1

C2 - I need to display "RED BLUE"

If

Worksheet 2

A2 = RB

Thanks in advance for any help you can provide.

benicio

[davesexcel]

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.

View Pic

[FDibbins]

Hi and welcome to the forum

You need to use vlookup() to search for what you want, but then you need to wrap that in
=if(iserror(your_vlookup)),"",what_you_want_displayed)

[benicio]

Example.xlsx

Example attached.


--FDibbins, can you look at the example workbook? I am unsure as to how to get the vlookup to function before even getting to the =if(iserror portion.

Thanks for helping nonetheless.


benicio

[FDibbins]

OK heres what I did. (there are a number of ways to solve this, but this is probably 1 of the easier ways).

1st, create a table where you have the abbreviations in 1 column and the colors in another - I used S2:T5 and had this...

RB...Red Blue
BG...Blue Green
RY...Red Yellow
YG...Yellow Red

Then on sheet1 C2, copied down, use this...
=IFERROR(VLOOKUP(Sheet2!A2,Sheet2!$S$2:$T$5,2,FALSE),"")

The data you provided is probably dummy data, so hopefully you can apply this to the real data?