Okay, I have pretty much got this right ( I think )
I basically want to enter the data on sheet two.. and sheet one summarises it into a table. The source could change and therefore I need the cross reference check to put it into the right position in the table.
The only problem I am having with it, is that it says True instead of giving a value... any help?
SEE ATTACHMENT
Thanks for any help.
EXAMPLE.xlsx
Perhaps in C4 and copy down and across
=IFERROR(INDEX(Sheet2!$E$5:$E$7,MATCH($B4,Sheet2!$B$5:$B$7,0),MATCH(C$3,Sheet2!$E$3,0)),0)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
In C4 Cell
Formula:
Please Login or Register to view this content.
Drag it down and right...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Perfect thank you. Was almost there myselfOriginally Posted by Fotis1991
I figured it would have been right but thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks