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