Having some problems with a simple vlookup formula.
Never experiened this before.
I keep getting a #ref
Here is the forumla I am using
=VLOOKUP("JK09",Feb!A2:A9,13)
What I am expecting is for excel to look up the value of "JK09" within the range of A2:a9 within the worksheet Feb, and when it finds it it will give me the value in coloum 13 of the macthing row.
Atatched is the spreadsheet
Bookmarks