Originally Posted by
buckchow
What I'm trying to do is create a formula that will look at the data in cell N8 on sheet1 (Form) and if there is a match on sheet2 (Contact) in column H then count four cells to the right and retrieve the data to sheet1, cell N10. I'm currently able to do that with a vlookup formula. The tricky part is that if the match cannot be found in column H, I want it to look in column J and if found retreive the data four cells to the right back to sheet1, cell N10. There's a total of 4 columns that I need to search for a match and retrieve the data four cells to the right from whatever the column the match is found in.
Attached is my worksheet for clarification.
Bookmarks