Need Help with Index and Match or Vlookup

[japorms]

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 retrieve
data from the reference if its only numeric.

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

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

 

[Biff]

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