Help Excel Vlookup Problem

[Mr DarkDonut]

Can anyone help me regarding this so dalawang sheet kase gamit ko yung isa input ng data so yung isang sheet doon ko kinukuha kaso kapag gumagamit ako ng vlookup sa pag input ng data sa isang sheet ganito sinasabi even thought tama naman yung formula ko.

 

[bbbrohm]

OR ito working din

=INDEX('[1 July 23 to July 29,2023 Texmex (2).xlsx]vlookup'!$AB:$AB,MATCH(B2,'[1 July 23 to July 29,2023 Texmex (2).xlsx]vlookup'!$H:$H,0))

 

[Mr DarkDonut]

dapat ganito ang formula mo:

=VLOOKUP(B2,'[1 July 23 to July 29,2023 Texmex (2).xlsx]vlookup'!$H:$AB,21,FALSE) OR =VLOOKUP(B2,'[1 July 23 to July 29,2023 Texmex (2).xlsx]vlookup'!$H:$AB,21,0)

sa video mo nawala yung B2 (lookup_value)

View attachment 2764518same thing parin po eh

 

[bbbrohm]

View attachment 2764518same thing parin po eh

try mo index match

 

[Mr DarkDonut]

try mo index match

diko pa po na try pero kapag ganito po siya nag wowork naman po

 

[bbbrohm]

diko pa po na try pero kapag ganito po siya nag wowork naman poView attachment 2764549

baka sa version na yan ng excel mo

 

[nbtesara]

kung ayaw pa rin isumifs mo na lang yan tutal unique naman code mo