index/match formula not working

**ea223** · 01-15-2013, 12:55 PM

Hi
can anyone tell me what i have done wrong with this formula:
=INDEX(Sheet1!$A$3:$T$500,MATCH(Sheet2!$A6,Sheet1!$A$3:$T$3,0),MATCH(Sheet2!$B$5,Sheet1!$A4:$A500,0))
it is bring back a 0 value instead of the value i want it to bring back.
thanks

**Fotis1991** · 01-15-2013, 01:04 PM

Reverse your formula to lookup first your rows and then your columns.

=INDEX(Sheet1!$A$3:$T$500,,MATCH(Sheet2!$B$5,Sheet1!$A4:$A500,0),MATCH(Sheet2!$A6,Sheet1!$A$3:$T$3,0))

**ea223** · 01-15-2013, 01:27 PM

Amazing, thank you!!

**Ranbir** · 07-28-2023, 10:56 AM

hi,

I have 2 sheets 1. LR_CNF and 2. Summary

LR_CNF sheet has container-wise loading data and we put BL no. against each container as
they sail and BL is issued.

in the Summary Sheet, under BL Status we intent to summarize BL only. if BL Coloumn is blank it should not be
populated

the formula used was working initially and now it stopped and not showing results after more
containeers are inserted in this sheet.

Kindly help is sorting the mistake if any in the formula or else advise.

Thanks
Ranbir

**AliGW** · 07-28-2023, 11:30 AM

Administrative Note:

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread