Afternoon all,
Im trying to pull data from a third column based on two matching criteria in two other column's either side.
I have attached an example of the layout and what data would be pulled.
Any help welcome thanks.
Afternoon all,
Im trying to pull data from a third column based on two matching criteria in two other column's either side.
I have attached an example of the layout and what data would be pulled.
Any help welcome thanks.
Is this what you are looking for:committed with Ctrl-Shift-Enter rather than just EnterFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Check my formulaGreetings.Please Login or Register to view this content.
Sorry i may have made an error on the example, im looking to pull through the time fo each route that will arrive at Base Camp
So need to be able to look up Route ID and Base Camp name.
OK, maybe this then:Formula:Please Login or Register to view this content.
Thats perfect thanks TMS
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks