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 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.

[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

"japorms" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>