Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with Index and Match or Vlookup
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index Match Vlookup or something else | Excel Discussion (Misc queries) | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Vlookup, index, match? | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |