I searched in the forum and couldn’t find any help
I have a table in excel and a row of headings.
I want to find the specific location of a heading “date” but I also have a column named “Date Of Insurance”
I tried to use the “lookup range” but it gave me the other value (date of insurance) because it was earlier in the search - the “date of insurance” is in column D and “Date” is in column X, and I want the one in column X
thank u all for the help