G
Guest
Hello, I was wondering if somebody could help me with a VLOOKUP formula.
VLOOKUP(A2,'MHP 01-03-2007 '!A13:T144,12,FALSE)
Is there a way to adjust the formula above so that the MHP 01-03-2007
portion of the above formula will reference the active sheets tab name
instead of hard coded text?
any help would be appreciated.
thanks,
Tim
VLOOKUP(A2,'MHP 01-03-2007 '!A13:T144,12,FALSE)
Is there a way to adjust the formula above so that the MHP 01-03-2007
portion of the above formula will reference the active sheets tab name
instead of hard coded text?
any help would be appreciated.
thanks,
Tim