vlookup instruction help

[albertldee]

hi i have to do a mail merge with letter can anyone share some idea how to do it

i have a workbook with 2 sheet, sheet 2 has the following info

sheet 2 cell has the following info
A1=END IN, B1=UNIT, C1=SLEEP, D1=DISC

A1= END IN (table headder)
A2= 1 bedroom
A3= 2 bedroom
A4= 4 bedroom
A5= Studio

SHEET 1 HAS THE FOLLOWING

this is what i want to do sheet 1 has

A1= ROOM, E1=DISC, F1=UNIT, I1=SLEEP

how can i used the vlookup function for cell E1, F1 AND I1 in sheet 1
so when i enter 1 bedroom in cell A2 it will look up the info in sheet 2 that correspond with 1 bedroom and put it in E1, F1 AND I1

Thanks in advace

 

[venkat1926]

=vlookup(a2,sheet2!$A$2:$A$20,4,false)
assuming you have data upto row no. 20
copy this formula wherever you want you get
DESC of that type of flat which you fill in sheet1-col A
in sheet 2 desc is in D1 4th column from col A being 1
that is why the third argument is 4
similar for others
I am sure now you get hang of it.
remember that the the type of flat llike 1 bedroom, studio etc
should be inthe first column of the database
in both the sheets

 

[albertldee]

i'm getting error with that code
invalid code reference error i have the same info in seet2 A1 that i'm putting in Sheet1 A2 i format all the cell to text when i paste the code in cell E2 (disc) i get a error

 

[venkat1926]

can you please send small extract of sheet 2 and sheet1 so that I can find whre I have done the mistake.