LinkBack URL
About LinkBacks
=INDEX($C$1:$C$6,MATCH(E1&F1,$A$1:$A$6&$B$1:$B$6,0))
where E1 and F1 contain the two search values to be combined. Adjust th eranges as required.
Array entered with Ctrl-Shift-Enter rather than just Enter
Regards
=INDEX($C$1:$C$6,MATCH(E1&F1,$A$1:$A$6&$B$1:$B$6,0))
where E1 and F1 contain the two search values to be combined. Adjust th eranges as required.
Array entered with Ctrl-Shift-Enter rather than just Enter
Regards
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks