LinkBack URL
About LinkBacks
Good day
Please assist
I have a Value in N2 I need a formula to look for the same Value in ColumnI and then return the corresponding data in Column F.
VLookup does not look to the Left and I can not move the columns
Hope this makes sense
Good day
Please assist
I have a Value in N2 I need a formula to look for the same Value in ColumnI and then return the corresponding data in Column F.
VLookup does not look to the Left and I can not move the columns
Hope this makes sense
Hi,
Please post a sample template of your workbook using "Go Advanced" option below.
Try
=INDEX(F1:I100,MATCH(N2,I1:I100,0),1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Why not just this...
=INDEX(F:F,MATCH(N2,I:I,0))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Good day
Thank you SpecialK, your formula is exactly what I needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks