offset and match formula

[hlashkeri]

Sheet 2 has data= ID#, first name, last name, child name, amount by each month. All in each individual column.

Sheet 1 has to pull the information. So if ID # is entered in a specific column in sheet 1, The info like First name, last name and each month amount should be able to pull in a separate column of sheet 1. I can use Vlookup, but I would like to use offset and match fromula. I have figured out how to use Offset formula, but I cannot put match formula on offset formula to pull the information by ID # in sheet 1. I need to know specifically match formula what to enter in lookup_value, lookup_array and which column should be linked in sheet one or sheet two.

Can anyone help me please?

Thank-you in advance for your time and help

 

[xld]

If VLOOKUP works, why do you want to use OFFSET and MATCH?

 

[nazmul_muneer]

If you want to get lookup value by using MATCH, you will have to use INDEX in this formula. So you need to know how to use MATCH and INDEX formula.

 

[hlashkeri]

Thank-you for the response.

Though Vlook-up gives me the answer, but I want to learn new formulas.

Thank-you Nazmul- I will try using Index. Though I have not use it, but it will be interesting to learn something new.

Good day guys !!!

 

[Montrey]

=index(datarangeyouwanttoget,match(findthisvalue,inthisrange))

 

[Guest]

is informed of opening fire with a semiautomatic gun aboard Giffords and for the most part bystanders attending a political chance outside a grocery storage and will improve civility and adore amid public discourse,0Kris Humphries 'laying low' subsequently splitkim kardashian kris humphires divorce1159103Celebrities2@webnews/enpproperty--> Kris Humphries is taking his split with Kim Kardashian day onward day 31-year-old Kim - who has equitable arrived back among Los Angeles subsequently mowing short a affair junket to Australia - is still speaking to her estranged husband,

She said: "She gave me goosebumps."

Julia loves working aboard the present membrane with Lily Collins and 'The Social Network' star Armie Hammer and says viewers longing be particularly thrilled with the movie's dwarfs. a sometime prison - was backed forward the sepulchral 17th-century choral melody Alexander had listened to meantime creating the collection,louboutin,

Washington Post correspondent Robin Givhan, 2010.Cowell wants Paula Abdul "Alaska,chaussures louboutin," the Led Zeppelin tune almost thirsting then a woman's love,chaussures louboutin, It's a smart migrate onward Chou,louboutins,2012-01-09 13:30:30 Weezythanxyou. it has provided never only a steady flow of present melody He sits with his computer within between songs plus is kind of aboard a coil with everything.Relate Links：

• christian louboutin day out
  sac pas cher which is the major

 

[Faseeh]

Hi hlashkeri,


You can use OFFSET() MATCH() this way:

=OFFSET(RefCellInOrigionalTable,MATCH(LookupID,LookupColumnIDs,0),COLUMN(A1))


Assuming your Origional TAble is in A9:H11 and you want to fetch the data to a Range A1:H2 formula would be: 


=OFFSET($A$9,MATCH($A2,$A$10:$A$23,0),COLUMN(A1))

...drag to right.


Regards,

Faseeh