F febausa Member Feb 18, 2015 #1 Please help in formula: I annex manual example for result in column CE:CH (fill with yellow color) . THANK YOU Attachments example-information-found.xlsx example-information-found.xlsx 9.3 KB · Views: 13
Please help in formula: I annex manual example for result in column CE:CH (fill with yellow color) . THANK YOU
N NARAYANK991 Excel Ninja Feb 18, 2015 #3 Hi , Can you not use HLOOKUP ? See the file. Narayan Attachments example-information-found.xlsx example-information-found.xlsx 10.3 KB · Views: 8
Deepak Excel Ninja Feb 18, 2015 #4 Always explain the issue in a nice & clear gesture. Check this CE4=IFERROR(ROUND(INDEX($A$44:$BW$44,BZ4),2),"") Drag it..
Always explain the issue in a nice & clear gesture. Check this CE4=IFERROR(ROUND(INDEX($A$44:$BW$44,BZ4),2),"") Drag it..
F febausa Member Feb 18, 2015 #6 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.. Click to expand... Thank you Deepak, you formula working very well
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.. Click to expand... Thank you Deepak, you formula working very well