=vlookup

  1. G

    Vlookup from particular cells

    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 <tbody> slno name 1111 asdf 2222 gadsffds 3333...
  2. E

    =VLOOKUPreturnstowrongrow

    =VLOOKUP returns b37 into c2 not into c37. why?
  3. S

    vlookup to look in a range for "What"

    Hi Can I use vlookup to look in a range instead of a cell the range will only have 1 cell with data =vlookup( A1:a9,data,0) =vlookup(criteria,data,0) Neither works mike <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/>...
  4. I

    removing an '#N/A' response from VLOOKUP

    Hi all, I am trying to create a formula using VLOOKUP where the returned value will be either the quantity found next to my array or if the VLOOKUP is unsuccessful, return a value of '0'. <TABLE style="WIDTH: 505pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=672...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top