Change content of one cell based on content of another

Hello it's been a while since I've had to format a spreadsheet and I am looking for some guidance please.

I have a Formula tab where I have a column with one value (ie. 1800) and the next column showing another value (ie. 2). What I am trying to achieve is to have the '2' appear in 'S14' (which is on worksheet May 7) when I place 1800 in 'D14' on that worksheet.

I really hope this makes sense.

Thank you in advance for your help.

Flora

It is impossible to provide any help to you unless you provide a sample workbook which is exactly same as your original workbook along with the sample data and the desired output on a different sheet or explaining in the sheet itself that what are you trying to achieve.

To attache a sample workbook. Click to Go Advanced, you will find a paper clip icon to upload a sample workbook by following the simple instructions.

Hi,

You don't say whether S14 should contain the E14 value if D14 ONLY equals 1800, or if D14 is a non zero value. I'll assume the latter, and also that all values are on the May 7 sheet.

Maybe in S14

Formula:

Please Login or Register  to view this content.

Thank you
I would like 1800 to equal to '2' so when I write 1800 in D14 the value of '2' appears in S14. So would the formula be =IF(D14<>2,S14,"")?

I've attached two images. one is the Formual Tab and the other is the May 7 tab.

I hope that clarifies what I'm trying to say.

Formula Tab.pngMay 7 Tab.png

Mr. Buttrey, I believe I got the formula.

I have placed =IF(D14<>0,Formula!B12,"") in the function and received a '2'. Does this sound correct to you? To add to this, how would I amend the formula so that it can read B13 as well as an alternate option?

Hi Flora,

Based on your example in the Formula tab I think you probably need a VLOOKUP() function

i.e.

Formula:

Please Login or Register  to view this content.

but if not upload the workbooks

Hi Richard,

Sorry I've been off for a few days and I'm still not concentrating very well, so I applogize if this post seems obscure.

I have placed =VLOOKUP('May 7'!D14,'Formula'!A$12:A$13,2.False) but it's giving me an error. In the Formula sheet A12=2 & A13=12. I've tried placing both values in the formula but it's not taking. I know this is an easy fix but I can't seem to figure it out.

I've uploaded the workbook for you. I have highlighted the two columns in the May 7th worksheet as well as the two rows in the Formula worksheet.



I really want to Thank you for all your help.

I think the formula in S14 on May 7 sheet should be........

Please Login or Register  to view this content.

You are getting #value error because A12:A13 has different format than that of D4. D4 is formatted as Text and A12:A13 is formatted as General. Make the format of lookup value and lookup array same and your formula will work.

I hope this helps.

Hi Flora,

Can you clarify exactly what you expect to see and add some typical entries and manually add the results you expect to see. I can see no reference to the Vlookup() formula you mention.

Neither am I clear whether the entries you show on the Formula sheet are the only entries that will ever be there or not. I suspect not since I'm presuming this is some sort of database that will list many employees.