Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Need to Column C to equal the text in Column G based on the match the value in Column B.

I do have Column C matching the row in which the value is found (based on columns B and F)

Column C's Formula =MATCH(B1,$F$1:$F$39,0)

In the first row, you'll see that I found the row its corresponding value row is in. In CELL C1 for example, I would want to see 112-Campaign Access

enter image description here

share|improve this question
add comment

2 Answers 2

LOOKUP is fine as long as B1 exists in F1:F39 (and because F1:F39 is sorted ascending), but what if B1 is 120? Your formula will return 113-Campaign Implementation. If you want #N/A in that case (as you would get with your MATCH function) then better to use VLOOKUP, i.e.

=VLOOKUP(B1,$F$1:$G$39,2,FALSE)

...or you can use INDEX with your MATCH, i.e.

=INDEX($G$1:$G$39,MATCH(B1,$F$1:$F$39,0))

share|improve this answer
add comment
up vote 0 down vote accepted

I suppose that I should have looked into this a bit more before begging for an answer. I'll keep the question here as it does provide some good info.

Using the function lookup, I was able to select the value in Column B and reference it to Column F and return the value in Column G

=LOOKUP(B1,$F$1:$F$39,$G$1:$G$39)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.