VLOOKUP in Excel

KiTBoH · 15 Apr 2009 at 21:21

I have an Excel worksheet, and I'm trying to lookup a 2 digit number (01, 53, 14) and then bring up a date from the second column.
It works fine when I search text. I entered abc into the table and when I searched it it came up with the correct date. It just won't work with numbers.

This is what I have so far

=VLOOKUP(B7,Sheet3!A4:B30,2,FALSE)

B7 is the number I am looking for.

A4:B30 The table that I am searching in. 2 is the column with the date. For Example

A B
01 February 2012
03 March 2003
04 June 2004

Any suggestions on what I could do to make it all work?

THanks

KiTBoH · 15 Apr 2009 at 21:58

Raist said:
Put B7 in quotes, I think. Or an apostrophe before. I forget which.

edit: scratch that. I thought you were looking for B7. I didn't read carefully. Never mind. Hold on.

Yeah, B7 is a cell with data that is input to it using a formula. I want to look up the result that was then put into B7.
The problem is caused because the result is a number, and for some reason it won't look up the numbers.

KiTBoH · 15 Apr 2009 at 22:21

Hamish said:
Are both columns formatted as the same type? i.e. both either text or number.

No, one's a number and one is text.

Would that be the problem?

KiTBoH · 16 Apr 2009 at 13:50

Does the VLOOKUP command search through the entire table, or just the left column?

KiTBoH · 16 Apr 2009 at 14:25

OK I know what the problem I am having is now.
I am using =MID(a1,2,2) to get the number that I am looking up.
It wont look up the number that is then given out.

How can I make it do that?

KiTBoH · 16 Apr 2009 at 21:41

suarve said:
If I'm understanding you correctly, you'll need to put that mid function inside the vlookup function for the lookup cell...if that makes sense.

How would I do that?

I tried =VLOOKUP(MID(A3,3,2),Sheet2!B8:C19,2) but that didn't work :/

KiTBoH · 18 Apr 2009 at 18:04

I managed to get the number table to work, by putting the Mid part inside the VLOOKUP.

Thanks for the help