Row Column
1 B F
2 LAP 1 SAP LCoA
3 34103 151150011
4 54915 530855000
5 34103 221000048
Above is a brief extract from the table I am working with.
Basically I am trying to search for the value in column B and return the relevant value from column F. However, as you can see, ‘34103’ in column B (B4 & B6) will return two results from column F (F4 & F6) and therefore (assume) rules out the use of vlookup?
Looking around on the internet, it seems as though the Index, If & Small functions are used within an array to produce the results I am after. However, I have been unable to get this to work.
My table properties are columns A:F and Rows 1:21801.
Thanks for your help.
Bookmarks