information find

febausa · Feb 18, 2015

Please help in formula:

I annex manual example for result in column CE:CH (fill with yellow color) .

THANK YOU

Syedali · Feb 18, 2015

Can you Elaborate your question

NARAYANK991 · Feb 18, 2015

Hi ,

Can you not use HLOOKUP ? See the file.

Narayan

Deepak · Feb 18, 2015

Always explain the issue in a nice & clear gesture.

Check this
CE4=IFERROR(ROUND(INDEX($A$44:$BW$44,BZ4),2),"")
Drag it..

Deepak · Feb 18, 2015

This too.

=IFERROR(INDIRECT(ADDRESS(44,BZ4)),"")

febausa · Feb 18, 2015

Deepak said:
Always explain the issue in a nice & clear gesture.

Check this
CE4=IFERROR(ROUND(INDEX($A$44:$BW$44,BZ4),2),"")
Drag it..

Thank you Deepak, you formula working very well

find information