lookup 2 values

Hi all, I am trying to build a formula looking up text values and then sort them by Month and category <tbody> Date Category Color Result Jan Feb Mar 1/1/2016 A Red A Red, Grey Blue, Brown 5/2/2016 A Blue B Yellow 1/1/2016 B Yellow C...

this is going to be a dreadful explanation so i will apologise but i shall try my best basically i have 2 look up tables higher and lower 2 columns where date can be imputed higher and lower but i want my answer to be displayed in only 1 column ill try and demonstrate below <tbody> higher lower...

Hello! Please comment if you have an idea about how to do this! I am trying to convert foreign sales prices dating back 10 years into USD amounts using a vlookup function embedded within an If function (I also tried a Lookup function) to return the appropriate conversion rate from the...

I am looking for a way to populate a summary table. I export multiple sources of data, which all have the same information but arranged in a different way. The constant would be the date that I keep on the far left. So what I am looking for is a way to use the date then look up the column...

Hi, I am fairly new to VBA and am looking for some advice. I am trying to write code that goes through two ranges in two separate columns, checks against a condition and returns a value if true. Crucially, for each value I'd like it to add a row below and return the next value. For the first...