Hello friends
In excel 2003 i have three sheets
calculate
fsr_ngp
fsr_akl
Now i have taken data from fsr_ngp with below formula and its work perfectly.
=INDEX(FSR_NGP!$C:$C,MATCH(I5,FSR_NGP!$F:$F,0))
But i required data from fsr_akl sheet if some data in this sheet with using above formula.
In view of the above confirm
Last edited by avk; 10-13-2011 at 04:27 PM.
I am not sure what you are really asking?
Can you elaborate?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
In calculate sheet i have index match using below formula.
=INDEX(FSR_NGP!$C:$C,MATCH(I5,FSR_NGP!$F:$F,0))
I reqired if the data not match with fsr_ngp then match from second sheet i.e. fsr_akl
and display in calculate sheet. Both sheet structure are same.
Above formula work perfectly but only from one sheet i required match from both sheets.
Ok, try:
Please Login or Register to view this content.
thanks. solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks