Macro or Excel IF statement

**dizooo** · 12-30-2009, 03:43 PM

I need a little help on whether this should be done with a Macro or an IF statement.

On the first tab, there is a field that the user inputs, and then i need to go to the second tab and if the field is in between the range of the column C and D, then i need to return Column A and E back to the first tab. But if it is not in the range, it needs to go down to the next line, and the next line until the range is met. Any ideas? I need a little help.

THANKS!

**Palmetto** · 12-30-2009, 04:15 PM

To help us understand and provide a precise answer, post a sample workbook that exactly duplicates the structure of your real workbook and contains a bit of representative data (non-sensitive). Manually show what the desired results should be.

**dizooo** · 12-30-2009, 05:52 PM

Here is an example.

**Palmetto** · 12-30-2009, 06:52 PM

Perhaps this is what you intended (though I added text in the formula).

=VLOOKUP($B$4,Data!$A$5:$E$12,1,TRUE) &" Minutes Ran, "& VLOOKUP($B$4,Data!$A$5:$E$12,4)&" Calories Burned"

Returns this result: 100 Minutes Ran, 120 Calories Burned

**dizooo** · 01-04-2010, 08:50 PM

Thanks for the help, however there is a loop hole. What if the variable that the user inputs is not in the range on the "data" tab? Nothing happends, can you put something in there that if it is over A5 and under A6, use A6?