Hey guys,
I need to do a VLOOKUP. I need to return a value from Column C corresponding to the Column B from the Cell in Column A (If that makes sense)
So if the RATING is 7 (As in column A) then find 7 in column B and return the value from column C. as below.
RATING.jpg
=vlookup(a1,b:c,2,0)
If I've helped U pls click on d *Add Reputation
A couple of ways: Assuming that the value to be looked up is in A5.
VLOOKUP that you have already been given:
Formula:
Please Login or Register to view this content.
INDEX MATCH
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks