• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Want to pull out all values with Vlookup without changing cell references manually

Hi Shivinder,

Without a sample, it is difficult to give you any suggestion. But here my try.

Considering your Lookup table is in A1:D10, with headers on row 1, and I will assume you want to extract all 2,3,4 column value in a single formula, without changing the formula column number of Vlookup formula to 2 , 3 & 4. Than try this,

Select 3 cells, Press F2 and put below formula
=VLOOKUP(M10,A1:D10,{2,3,4},0) and press Ctrl+Shift+Enter. Your three cells will be populated with all the values Here Look up value is in M10.

Just advise if you have some other issue.

Regards,
 
Shivinder Kaushal said:
Hi Somendra,

Thanks a million for supporting me with your great assistance. :)

Regards
Shivinder Kaushal
Click to expand...
Somendra Misra said:
Hi Shivinder,

Without a sample, it is difficult to give you any suggestion. But here my try.

Considering your Lookup table is in A1:D10, with headers on row 1, and I will assume you want to extract all 2,3,4 column value in a single formula, without changing the formula column number of Vlookup formula to 2 , 3 & 4. Than try this,

Select 3 cells, Press F2 and put below formula
=VLOOKUP(M10,A1:D10,{2,3,4},0) and press Ctrl+Shift+Enter. Your three cells will be populated with all the values Here Look up value is in M10.

Just advise if you have some other issue.

Regards,
Click to expand...


Hi Somendra,

If i am applying the below formula between two sheets its not working. I want to show all values in sheet 2 from sheet 1 without changing the formula column number.

=VLOOKUP($C14,Sheet1!$A$5:$I$13,{2,3,4,5,6,7,8,9},0)

it shows all values same which is due to locked cell number ($C14). Kindly assist

Regards
Shivinder Kaushal
 
Somendra Misra said:
Hi Shivinder,

I could not got your problem. See in the attached file, I had tried to show the working with lookup table on Sheet1 and lookup value with formula on sheet2. Its working.

Can you state your problem once again.

Regards,
Click to expand...

Have tried the same, now its working.....thanks again Somendra !!
 
You must log in or register to reply here.
Back
Top