Vlookup on Visible cells after filter particular value

**[email protected]** · 09-07-2014, 02:22 AM

Hi Friends,

I want to filter the value of "#N/A" in a particular column and apply vlookup formula on those cells only(Non Hear cells)

And every time the value "#N/A" appear in different cells hence it should be dynamic.

Example i need to apply filter "#N/A" in column "N" and apply vlook up to get values only for "#N/A" cells.

Regards,

Prabhu

**NeedForExcel** · 09-07-2014, 02:35 AM

Do you basically want to get rid of the #N/As or do you want to look up a Value when there is #N/A?

**[email protected]** · 09-07-2014, 02:45 AM

YES,want to look up a Value when there is #N/A?

**Vikas_Gautam** · 09-07-2014, 05:40 AM

Provide a sample workbook, if it is possible..
Else try this..

Formula:

Please Login or Register  to view this content.

Replace
"Lookup_Range"
"Output_Range"
"Lookup_Value"
with the respective ranges...

**NeedForExcel** · 09-07-2014, 05:51 AM

Here!

Try This. Assuming you data is in A1 that can potentially contain #N/A Error. Put the Formula in B1 & Drag Down.

Please Login or Register  to view this content.

Whatever Value you want when #N/A Error is found, put in in Place of 50 in the Formula.

Hope it helps!

Deep

**NeedForExcel** · 09-07-2014, 05:52 AM

Here!

Try This. Assuming your data is in A1 that can potentially contain #N/A Error. Put the Formula in B1 & Drag Down.

Please Login or Register  to view this content.

Whatever Value you want when #N/A Error is found, put in in Place of 50 in the Formula. Note this will only take into account #N/A Errors.

Hope it helps!

Deep

*** Dear Forum Admin, Posted Duplicate Posts by Error. Please delete the Post above this one. Sorry for the inconvenience ***

**[email protected]** · 09-07-2014, 07:51 AM

Hi All,

I could not apply the formula in VBA.

I have attached the sheet in the sheet1 column "C" few cells has #N/A value.

To get value for #N/A cells from sheet 2 to Sheet 1 , i need to concatenate A & B column in both Sheet1 & 2 from #N/A cell to get matched value from sheet2

Kindly help to get VBA code for the same.

PS: i have tried by filter in the sheet 1 but number of records are not fixed.