Help with a formula

Muke

New member
Joined
Aug 12, 2012
Messages
28
Reaction score
0
Points
0
Hi there,

I have the attached spreadsheet and I need to get the value in column G to look at the list in column M and then return the value in column N to column H.

I have tried various variations with LOOKUP and VLOOKUP with no luck.

Please help, I'm trying to impress the Mrs!
 

Attachments

  • TEST1.xlsx
    12.5 KB · Views: 14
Good afternoon,

Do you mean like this?

In H4: =VLOOKUP(G4,M:N,2,FALSE)

Let me know if I'm off. I may not be understanding correctly.

Best of luck,
 
That looks perfect! Thanks very much indeed. I think I was misunderstanding the column index and range lookup sections.

Thanks again, your help really is appreciated.
 
Back
Top