I'm trying to capture the dates

[solazie]

Hi,

I attached my sample workbook in here.

I'm trying to get my ETA on my grid however its just giving me N/A

I used hlookup for it but it doesn't work. I don't know how to get pass to this.

Thank you,

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[solazie]

Hi,

One way

Please Login or Register  to view this content.

I dont know if I'm doing it wrong but it doesn't give me the right ETA date, its just keep giving me 43101 or 1/1/2018

[63falcondude]

Try this:

=INDEX(ETAs,MATCH(C6,INDEX(Trial,MATCH(C3,superSKU,0),),0))

With 20038 in C3 and 10008 in C6, the formula should return 1/1/2018 (which is 43101 formatted as a date).

Are you expecting a different result? If so, what result are you expecting?

[solazie]

try this:

=index(etas,match(c6,index(trial,match(c3,supersku,0),),0))

with 20038 in c3 and 10008 in c6, the formula should return 1/1/2018 (which is 43101 formatted as a date).

Are you expecting a different result? If so, what result are you expecting?

omg! You guys are awesome!!

Thank you!!!

[63falcondude]

You're welcome. Glad we could help.

[Richard Buttrey]

That value 43101 is a date number. You need to format it as a date i.e. 1/1/2018 which is the date in R7 of the Consolidated sheet, i.e. the column with the quantoties value of 10008 in R34.

What date do you expect & why?

[solazie]

Try this:

=INDEX(ETAs,MATCH(C6,INDEX(Trial,MATCH(C3,superSKU,0),),0))

With 20038 in C3 and 10008 in C6, the formula should return 1/1/2018 (which is 43101 formatted as a date).

Are you expecting a different result? If so, what result are you expecting?

Hi,

I just want to ask something base from your formula, I found out the , in the plays a very important rule and as the last zero in the end..

would you mind explaining to me farther?

Thank you

[63falcondude]

As for the lonely comma towards the end of the formula, the formula can also be written like this:

=INDEX(ETAs,MATCH(C6,INDEX(Trial,MATCH(C3,superSKU,0),0),0))

That 0 is the column number portion of the second INDEX.


The 0 at the end of the formula ensures that the INDEX MATCH function pulls an exact match rather than allowing the formula to default to an approximate match (-1 or 1).

[solazie]

Thank you!!