Hi Guys,

Sorry about this but this one still confuses me.

Can someone help me with index and match or vlookup?

I have this function below

VLOOKUP(G1569,'AUGUST 15 PAYMENT DETAIL'!$C$4:$I$1021,1,FALSE)

but it doesnt get the value that is alphanumeric. It only retrieves
data from the reference if its only numeric.

I need the formula to also get the data even if the the reference is
alphanumeric.

Can someone please help me with this? Thanks in advance. :)


--
japorms
------------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=567598

Hi!

There's nothing wrong with your formula so any problem you're having is
related to the data itself. Unseen characters like leading and/or trailing
spaces, TEXT numbers versus NUMERIC numbers are common issues.

Biff

"japorms" wrote in
message ...

Hi Guys,

Sorry about this but this one still confuses me.

Can someone help me with index and match or vlookup?

I have this function below

VLOOKUP(G1569,'AUGUST 15 PAYMENT DETAIL'!$C$4:$I$1021,1,FALSE)

but it doesnt get the value that is alphanumeric. It only retrieves
data from the reference if its only numeric.

I need the formula to also get the data even if the the reference is
alphanumeric.

Can someone please help me with this? Thanks in advance. :)


--
japorms
------------------------------------------------------------------------
japorms's Profile:
http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=567598