LinkBack URL
About LinkBacks
Here is an example.
Here is an example.
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
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks