I'm using index match but I'm trying to pull data from a cell but the look up values are in two different columns. Im trying to get it to look at one column first if they have text in it then use that data to look up the data thats needs to be matched if not then use data in a separate column. now the data in the first column that i want it to lookout is being supplied through a formula also.
Bookmarks