Unable to place VLOOKUP code in address bar for worksheet cell

[ipbr21054]

Please see attached screenshot
I select the cell C20 which is the green one in image.
In the address bar i paste & also typed =IFERROR(VLOOKUP($B20,$F:$H,3,FALSE),"")
but when i the hit enter to have it applied when i click in cell C20 nothing is shown.

I expect to see the type formula there.
Im trying to have the cell populate the text from the yellow cells top right.

 

[etaf]

you will only see the formula in the formula bar - in the cell should be the results - in this case a blank as it will produce an error

change to
=VLOOKUP($B20,$F:$H,3,FALSE)
and you should see N/A

 

[ipbr21054]

Are you sre because the cell to the right is empty.
I click in it & see formula in address bar & cell not have N/A

SEE image so im trying to do the same. without N/A

 

[etaf]

yes , but you have an IFERROR to show a blank if not found
if vlookup cannot find anything it returns N/A , which is the case and because you have an iferror to return a "" - then its blank

either try as i posted and you will get N/A
OR
put somehting in B20 - that is in the list
like
asda
toolstation etc

 

[ipbr21054]

I make selection in column B
I enter formula in address bar for next column & i see value but formula now gone.

It doesnt do that for the following column

 

[etaf]

sorry i dont understand the issue fully now

 

[ipbr21054]

In column A I make selection from drop down box. The selection list is taken from column F

At the time in column D I had the formula to add value in the cell taken from column G

So now I wish to make use of column C to take value from column H

Example.
In the next row in column B I select LOCKING POST OFFICE.

I now expect in the next 2 columns to see 4 & POST PARCEL


This is my issue.
When I put the formula for column C in place then hit enter it’s gone.

 

[etaf]

i guess we need to see a copy of the spreadsheet to understand, at least i do - other members maybe able to work out from description and image - i'm afraid i cannot
not going to get anything from images
not sure xl2bb will help here anyway


MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[RoryA]

If the formula is being removed, then either code is doing that, or you have a userform with a control linked to that cell.

 

[ipbr21054]

If the formula is being removed, then either code is doing that, or you have a userform with a control linked to that cell.

Morning.
I removed all the code on that sheet in question.
I then add my Formula & then copied it down the sheet,so far all is fine.
I then put all the code back on that sheet, so far all fine.
So that over come the issue once saved.

My table where the values are taken from are shown below.
The mileage value & formula used works fine.

The cells in column H at present some are empty.

The formula use is =IFERROR(VLOOKUP($B3,$F:$H,3,FALSE),"")

But as we know it will return 0 as nothing was found.

How can the formula be written without IFERROR or what can i do so 0 & N/A isnt entered into the cell, or is that impossible ?

Thansk