Hi,
I'm looking for help with a vlookup.
I want to look up a value in another sheet as normal except not have it fixed to return from a specific column like a standard vlookup does.
I want it to select the column it returns the value from based on whatever month is indicated in a specific cell in the first sheet.
I think the attached sheet shows what I'm trying to do. Chat GPT failed as I kept getting errors. Can anyone here figure it out?
Much thanks!!
Bookmarks