Trying to use VLoolup and If statement

January 4, 2017 at 06:47:08
Specs: Windows 10
I'm trying to vlookup on my main sheet a "Team" then return the value in column 2 on the corresponding teams tab if the team name matches. Can't seem to get it to work. Here's one of the formulas I've tried:

=VLOOKUP(J1,'Main Data'!A:A,IF('Main Data'!A:A="HC - Magnolia",2,0))


See More: Trying to use VLoolup and If statement

Reply ↓  Report •


#1
January 4, 2017 at 08:08:35
You have it wrong way 'round.
You need to wrap the VLOOKUP() in the IF()

Something like:

=IF(VLOOKUP(J1,'Main Data'!A:A,2,0)="HC - Magnolia","Found It","Not Found")

Is that what your looking to do?

Check out this page for a quick tutorial on VLOOKUP()

https://support.office.com/en-us/ar...

And, in the future, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question