Search results

This will work. Thank you very much.

Expected results should be if cell (1) = "CUR" and cell (2) ="Active" then result is Current

Here is a sample of my data

Hi there, I'm trying to right a forumla that will compare two cells. They cells have data that in combination will produce an "answer" . SOmething like this: if cell D1="Cur" and cell E10="Active" then return "Current". I've tried many ways, but I'm just missing something where it's not...

Thank you for your responses. I'm sorry I could not load the data. In the future, I will create sample data with no confidential information.

I actually just figured it out after much trial and error. For anyone else who is wondering what the answer is see below. =IFERROR(VLOOKUP 1,IFERROR(VLOOKUP 2,VLOOKUP 3)) So my formula looks like this: =IFERROR(VLOOKUP(A:A,'OBS_Replaced by Parts'!A:A,1,0)...

The file has confidential information so I cannot load it and it is very large.

Hello All I have a vlookup with Iferror and it works great, however, I need to add another lookup and am at a loss for how to do this. The current lookup is as so: =IFERROR(VLOOKUP(A:A,'OBS_Replaced by Parts'!A:A,1,0),VLOOKUP(A:A,'OBS_Replaced by Parts'!Q:Q,1,0)) I need to add another...

Thank you so much. I always get great replies from this forum. Great talented folks!

Thanks so much. I'll keep this one in my back pocket. The % will change but not until the next fiscal period.

I think I just answered my own question .. Please correct me if I'm wrong. It seems to be working. =IF(B2>=516800, "A", IF(B2>=183116, "B", IF(B2<516800, "C")))

Hello all, I'm trying to make one formula to assign, A, B or C depending on the dollar value in a cell. I can write the formulas separately but putting them together I'm really confused A:> $516,800: 80% B: $183,116 – $516,800 : 81%-95% C: < $183,116: 96% - 100% =IF(B2:B2>516800,"A")...

Thanks for the response Khalid .. I got it figured out so I'll post it for others to lean from; As it turns out, I didn't need to the 'Item Cost' tab after discussion with the management - that made things a little easier. I address the leading zeros in the formula below...

Thank you for the reply. I was able to remove the reference to the item cost tab (it's not needed any longer) The problem is different. When I looked closed at the data, the problem seems to be two fold : 1) Lookup value is text 2) array is general/ number The array has leading zero's for...

I have formulated a Vlookup that looks for cost in two different excel tabs. The first step is to look in the "item cost" tab and if the cost is not found there to go look in the "cost pull from backend" tab. If cost is not found on either tab then "No Cost" should appear in the cell. My...

Thank you so much for your assistance. Love this forum. Replies are always speedy and helpful.

THank you for the reply. I will keep this in my notes of excel forumlas.

Thank you. I actually used the suggestion for test to column resolution someone suggested and it worked.

I am not sure what you mean by activate "looks like cell". I don't get anything with an apostrophe before the number I have attached the raw file. the data is dumped from the system of record as an *.xls file and sent via outlook if this helps any.

I am trying to convert general text to a date . the raw data that gets pulled in to an excel worksheet looks like this 50119 and I'm trying to find the formula in excel to convert that to 05/01/2019. I've tried =date, =datevalue and I'm not having any luck except to get some while date in...

Thank you. You've been very helpful.

Chihiro Sorry for the confusion, I thought was specific. It's parts number and revisions in text format. I'm just trying to loop through the list of objects in the named range or list of objects to get to to get a string (EPDBOMDP.PITEM In(‘ABC’,’XYZ’,’JKL’,’MNO’,’DEF’) and...

yes, what is stored in the named range is the information for part and revision for In("&list&") in the where statement above.

Chihiro Thanks so much for your response. so my " & list & " would be my name range? Am I understanding this correctly?

I have kind of evolved since I posted this .. My original code was in Excel pulling data From the db source using Excel. SELECT EPDBOMDP.CLEVEL, EPDBOMDP.PITEM, EPDBOMDP.PREV, EPDBOMDP.SITEM, ITMRVA.IDMO, EPDBOMDP.SREV, EPDBOMDP.SDESC, ITMRVA.EDAT, ITMRVA.EATO, EPDBOMDP.SIMSTS...