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))
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.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |