May be INDEX & MATCH formula needed (working with two sheets).

**nicholes** · 04-09-2012, 03:22 AM

Hi, i am working with two sheets but i am not getting the formula i am very week in programming.

i have attached a file
and here is what i want..

i want when i write name in sheet two in(A2,3,4,etc.) and price in B2,3,4,etc. the price should go in sheet one in front of name.

i have tried a formula but that does not work for me.

PLZ note i have purposely given some blank space in sheeet one.

**Haseeb Avarakkan** · 04-09-2012, 03:28 AM

Hello nicholes,

The formula should be,

Please Login or Register  to view this content.

You could also use VLOOKUP

Please Login or Register  to view this content.

If you want to avoid error values use =IFERROR(your_formula,"")

**nicholes** · 04-09-2012, 03:36 AM

Originally Posted by Haseeb A

Hello nicholes,

The formula should be,

Please Login or Register  to view this content.

You could also use VLOOKUP

Please Login or Register  to view this content.

If you want to avoid error values use =IFERROR(your_formula,"")

THANKS! thats great to get solution within a minute !

**nicholes** · 04-09-2012, 07:15 AM

what is one sign in your formula "$" i locked by using F4 key and your formula has only one $ sign

mine =INDEX(Sheet2!$B$2:$B$9,MATCH(Sheet2!A2,Sheet1!$A$2:A8,0))

your =INDEX(Sheet2!B$2:B$9,MATCH(A2,Sheet2!A$2:A$9,0))

can anyone explain what is the difference between one $ sign and two $$ ???

EDIT:- can you plz throw some light on Vlookup formula too (if possible)
BTW i am looking about it on YouTube right-now.
THANKS!