Forum Discussion
Need to match two columns and return a further field
Hi, I am new to this so here goes. I want to match column A and column D and return Column B entry in Column E where they match. Can anyone help me with a formula please?
Hi Tracey
In column A you have text and in column D numbers. If you transform what both will be text or both numbers your formula works.
Or you may make transformation within the formula like
=IFERROR(VLOOKUP(TEXT(D3,"General"),$A$2:$B$34,2,FALSE),"")
and attached
Thank you, that worked perfectly.
You are welcome
