Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel help PLease!!!!!!!!!!!!!!!!!!!!!!?
How do I find Vlookup function that looks up the tour codes,copmares it to the tours table,and returns the description.
$1,699 2.5% 10 Adventures in Canada 6/11/2012 $1,699.00
$1,749 3.0% 20 Check Out the Czech Republic! 6/4/2012 $1,799.00
$1,799 3.5% 30 Croatian Wonders 6/11/2012 $1,899.00
$1,849 4.0% 40 Live it Up London 6/18/2012 $1,699.00
$1,899 4.5% 50 Parisian Pleasures 6/25/2012 $1,749.00
60 Roaming Rome 6/11/2012 $1,849.00
70 Viva España 6/25/2012 $1,799.00
ty
1 Answer
- Anonymous8 years agoFavorite Answer
Use a combination of the INDEX and MATCH functions. You didn't state what columns your data is in, nor which cell the tour code is located. If you still need help, you can email me at nobodyspecial744@yahoo.com.