Excel Simplified Query

[Excel_77]

Hi,

I have unique IDs in column A of "tab 1" with the same IDs in column A of "tab 2".

What I want to do is within Column E of "tab 1," is the following:

1. I want to check the ID in column A, and then if the value in the heading of "tab 1" called "topic" = "Ice Cream Van [1]" and if heading "Breakfast" = "n/a" then I want heading "Result 1" returned from "tab 2" ensuring the IDs match from column A.

2. If the value in the heading of "tab 1" called "topic" = "Ice Cream Van [1]" and if heading "Breakfast" = anything other "n/a" then I want heading "Result 2" returned from "tab 2" ensuring the IDs match from column A.

3. If the value in the heading of "tab 1" called topic = anything other than "Ice Cream Van [1]" I want "Result 3" returned from "tab 2"

I don't think this will be possible but I thought I would try.

Thanks in advance

 

[Atroxell]

This is kind of unclear. Can you share some sample data? And the way your end result would look if you had it working?

Thanks!

 

[Excel_77]

This is kind of unclear. Can you share some sample data? And the way your end result would look if you had it working?

Thanks!

Is there an easy way to share sample data?

 

[Atroxell]

Easiest is to use HTML builder and copy data and/or code into the thread. You can find links here: https://www.mrexcel.com/forum/board-announcements/515787-how-post-your-vba-code.html

 

[Excel_77]

Easiest is to use HTML builder and copy data and/or code into the thread. You can find links here: https://www.mrexcel.com/forum/board-announcements/515787-how-post-your-vba-code.html

Only seems to relate to code, no idea how to upload raw data.

 

[Atroxell]

Only seems to relate to code, no idea how to upload raw data.

You're right--that was pretty much useless... Sorry.

Try this: http://Dropbox - MrExcelHTMLMaker20170807.xlam

You'll need to put it in your xlStart folder, the nclose and reopen Excel. It will be a tab in your ribbon after that.