LinkBack URL
About LinkBacks
Hi,
CAn somebody please have a look at the workbook I've attached.
I need a VLOOKUP to return values from the first sheet (M&E Rates) in the Total column of sheet 2 (SOR).
So far I'm getting #NA errors etc. ?
Thanks a lot.
Hi,
CAn somebody please have a look at the workbook I've attached.
I need a VLOOKUP to return values from the first sheet (M&E Rates) in the Total column of sheet 2 (SOR).
So far I'm getting #NA errors etc. ?
Thanks a lot.
It is unclear from your formula, what you are really trying to do... what exactly are you looking up in the active sheet and where should if find a match?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Good point.
I need to look up the [B][I]Ref(column C) in the M&E Rates sheet and then the value of the rate (column H) into SOR sheet, also column H rate.
Hope this clarifies ?
Thanks for your help.
Perhaps, then you want this in H3:
=VLOOKUP(C3,'M&E Rates'!$C$3:$H$40,6,FALSE)
copied down.
You're a life saver !
Seriously, that's saved me so much work.
Thanks a lot.
You are welcome... Have a look at Vlookup in Excel help.. it explains the function well and gives good examples.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks