LinkBack URL
About LinkBacks
Hi - I'm struggling with this.
Sheet2.A1 = Cat
On Sheet1, I want to find Cat in Column C and then Offset down 2 rows and over 57 columns
Put result on Sheet2, B2
Thank you!
Hi - I'm struggling with this.
Sheet2.A1 = Cat
On Sheet1, I want to find Cat in Column C and then Offset down 2 rows and over 57 columns
Put result on Sheet2, B2
Thank you!
Last edited by ker9; 02-07-2014 at 03:08 PM.
=OFFSET(INDIRECT("Sheet1!C"&MATCH(Sheet2!A9,Sheet1!C1:C10,0)),2,57,,)
make the references absolute.
Hope this helps
You could use index and match as well
=INDEX(Sheet1!$C$1:$BG$8,MATCH(Sheet2!A1,Sheet1!$C$1:$C$8,0)+2),57) if data starts from C1 if from A1 then
=INDEX(Sheet1!$A$1:$BG$8,MATCH(Sheet2!A1,Sheet1!$C$1:$C$8,0)+2),55)
Last edited by hemesh; 02-07-2014 at 03:00 PM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Perfect - thank you. I was close but struggling to get it just right.
Thanks for the feedback and Rep !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks