VLOOKUP Not Showing Result ?

Aitch

Board Regular
Joined
Jan 27, 2019
Messages
61
It's a pretty simple function - just look down the column range and display the cell that is not blank...

=VLOOKUP("?*",A2:A12,1,0)

It works when there is text in the cell - but gives an error when the cell shows a number?

What is the fix?

Thanks for your help!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,712
Office Version
365
Platform
Windows
It's a pretty simple function - just look down the column range and display the cell that is not blank...
If there is only one not blank then
=SUM(A2:A12)

Otherwise try
=INDEX(A2:A12,MATCH(TRUE,INDEX(A2:A12<>"",0),0))
 
Last edited:

ClaireS

Board Regular
Joined
Jul 29, 2013
Messages
137
If you know that you have an entry, but it could be text or number, then:
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IFERROR(VLOOKUP("?*",A2:A12,1,0),MAX(A2:A12))[/FONT]
 

Aitch

Board Regular
Joined
Jan 27, 2019
Messages
61
Thank you! I'd have never thought of using SUM or MAX - even though it's so obvious lol!

Is there a specific reason why VLOOKUP doesn't play well with numbers?
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,712
Office Version
365
Platform
Windows
Thank you! I'd have never thought of using SUM or MAX - even though it's so obvious lol!
You're welcome. :)


Is there a specific reason why VLOOKUP doesn't play well with numbers?
Being in quotes, your lookup value "?*" is specifically saying it is a Text value that you are looking for.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,644
Messages
5,469,895
Members
406,674
Latest member
melley

This Week's Hot Topics

Top