Vlookup from particular cells

[GirishDhruva]

Hi everyone

Below i am stuck with one problem, that how to perform vlookup for only selected cells.

Here i have 2 sheets, from sheet2 i have to perform vlookup only for specific cells in Sheet1 row B
Can that be done?????

Sheet 1

slno	name
1111	asdf
2222	gadsffds
3333	asdfqwer
4444	gfaser
5555	wqerf
6666	vadsfgrwa
7777	=vlookup
8888	=vlookup
9999	=vlookup

<tbody>
</tbody>

Sheet 2

slno	name
7777	asdfsadg
8888	afsdfew2
9999	fdsgvdv

<tbody>
</tbody>

Thanks in advance

 

[Special-K99]

Cells can contain a value OR a formula, not both.
And if a cell contains a formula and you enter a value the formula will be overwritten (and vice versa).

Maybe do something like this

In sheet 1

1. Enter your slno in column A
2. Enter your name values in column B (if you want a VLOOKUP leave the value in column B blank)
3. in Column C
=IF(D2="X",VLOOKUP(A2,Sheet2!$2:B1000,2,0),B2)
copy down the column

4. Now in column D put X if you want to perform a VLOOKUP of the slno otherwise the data will be copied from column B.

So your output is now in column C and will consist of a mixture of values from column B and VLOOKUPs where you specify an X in column C.

NOTE: If you're going to copy that data from column C elsewhere you'll need to Paste Values as or you will end up copying the formulas which you probably don't want.

 

[GirishDhruva]

Cells can contain a value OR a formula, not both.
And if a cell contains a formula and you enter a value the formula will be overwritten (and vice versa).

Maybe do something like this

In sheet 1

1. Enter your slno in column A
2. Enter your name values in column B (if you want a VLOOKUP leave the value in column B blank)
3. in Column C
=IF(D2="X",VLOOKUP(A2,Sheet2!$2:B1000,2,0),B2)
copy down the column

4. Now in column D put X if you want to perform a VLOOKUP of the slno otherwise the data will be copied from column B.

So your output is now in column C and will consist of a mixture of values from column B and VLOOKUPs where you specify an X in column C.

NOTE: If you're going to copy that data from column C elsewhere you'll need to Paste Values as or you will end up copying the formulas which you probably don't want.

Thank you so much for your reply , this helped me