Good morning/afternoon,
I am trying to cross reference values in a column of data with values in 4 cells in a row at the top. So I need the value in column A to match up with the correct value in columns B1, C1, D1, or E1 and then return the reference associated. So for example the Responsible Party value for cell F4 should be Ruth Schmidt. I have a couple attachments as a visual aid.
Any assistance would be appreciated!
testdata.jpg
Hi there. Use this:
IFERROR(=INDEX(B2:E2,,MATCH(A2,$B$1:$E$1,0)),"")
copied down
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
.. with your file:
That solved it, thanks!
You're welcome... and thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks