I am running into a issue with Vlookup where I have a list of Primary Asset IDs that I need to locate on a second sheet and return the Effective Date. The problem I am running into is that the second sheet is from an export from one of our programs and the column headers may be in a different order depending on the settings of each individual user. Below is the current formula I have right now.
=VLOOKUP("PL"&RIGHT(B2,6),'FOF TS'!A:BC,MATCH("Original Price Date",'FOF TS'!A1:BC1,0),FALSE)
I have the Match function to pull from the correct date column, but I don't know to get the Lookup array to pull from the Primary Asset ID column. This formula works if the Primary Asset ID is in column A but this wont be the case with every user. I have tried a few different versions of Vlookup and Match, and Index and Match but still come up with #N/A. Can anyone tell me what I am missing?
Thanks
=VLOOKUP("PL"&RIGHT(B2,6),'FOF TS'!A:BC,MATCH("Original Price Date",'FOF TS'!A1:BC1,0),FALSE)
I have the Match function to pull from the correct date column, but I don't know to get the Lookup array to pull from the Primary Asset ID column. This formula works if the Primary Asset ID is in column A but this wont be the case with every user. I have tried a few different versions of Vlookup and Match, and Index and Match but still come up with #N/A. Can anyone tell me what I am missing?
Thanks