Hi all, I’m sure this will be simple to some of you clever bods out there but it has stumped me!
I’m trying to get a formula to work where I have a lot of values (many are duplicates) in Column A and I want each one to be matched to its corresponding number in column B and to return the corresponding result from column A in to the cell in column C
It’s really hard to explain (and therefore to find an answer in a search!) – I have attached a file showing the layout and also have highlighted in yellow the expected result and in blue the ‘feeder’ cells
I can’t sort any column other than A and I’ve had a go with lookups etc
Very many thanks in advance
Rae
Bookmarks