Register
Log In
Unanswered
Home
June 16, 2015
Offline
Hi, based on the attachment, I have a situation whereby I need to return value in column C with specific value in column J, whereby column A&B must match column G&H.
i try using the solution provided in the following link https://www.myonlinetraininghub.com/vlookup-multiple-values-in-multiple-columns
but couldn't get the answer as it's return error.
Hope anyone can assist.
Regards.
Khalil
See Answer
Dashboards
June 25, 2016
Offline
Hi Khalil
See if this is what you are looking for.
Note that this is an array formula so you will need to press CTRL+SHIFT+ENTER (instead of ENTER) to complete the formula.
Hope this helps.
Sunny
Answers Post
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
