Search:

Type: Posts; User: boojooo; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    223

    Re: IF EXACT Formula with multiple chains

    Thank you tyija1995 and special-k99, you're both right and that's exactly what I was look for!
  2. Replies
    4
    Views
    223

    IF EXACT Formula with multiple chains

    Hello,

    I am attempting to do an IF/EXACT formula that contains two different values. Here is the formula that I've come up with, but it keeps returning a #N/A value:
    ...
  3. Replies
    9
    Views
    167

    Re: IF/OR Formula Involving Multiple Cells

    Also forgot to thank Fluff, thank you!
  4. Replies
    9
    Views
    167

    Re: IF/OR Formula Involving Multiple Cells

    Sorry about that JoeMo & Scott R. Got pulled away in a meeting and wasn't able to provide a better response. I was able to work that equation with your inputs. Thank both of you very much for your...
  5. Replies
    9
    Views
    167

    Re: IF/OR Formula Involving Multiple Cells

    That formula is returning a blank value even though there is data is cell B2.
  6. Replies
    9
    Views
    167

    Re: IF/OR Formula Involving Multiple Cells

    That equation is giving me an #N/A error, though there is a value in B2.
  7. Replies
    17
    Views
    360

    Re: Bit of a Tricky One

    Lol, you're right on the second one. I got a little do () happy.

    The first equation worked perfectly! Man that was driving me nuts when the zero's kept appearing randomly. Thank you again for...
  8. Replies
    9
    Views
    167

    IF/OR Formula Involving Multiple Cells

    Hello,

    Got a bit of a crazy one, I have 8 cells (A1 - D1 & A2 - D2), cells A1 - D1 are column headers and contain no formulas, while cells A2 - D2 contain formulas that will either return a value...
  9. Replies
    17
    Views
    360

    Re: Bit of a Tricky One

    No worries, you've been a lot of help! I tried that IFERROR solution, it's working but it not's working on a similar formula. Any suggestions?

    =IF(H3=8,(VLOOKUP(B3,'B:\Menu...
  10. Replies
    17
    Views
    360

    Re: Bit of a Tricky One

    Interesting, I was getting back zero's (0) is some cells when the formula was working correctly, but for the life of me couldn't figure out why. Let me input that and see if that clears it up.

    My...
  11. Replies
    17
    Views
    360

    Re: Bit of a Tricky One

    That's not a bad idea, but in this instance I wouldn't want to see an error returned to let me know that something went wrong. If it returns a blank, that tells me nothing has been inputted in the...
  12. Replies
    17
    Views
    360

    Re: Bit of a Tricky One

    That worked, thank you! Sorry about the delay, too many formulas in my spreadsheet cause it to error out for a bit before coming back up.
  13. Replies
    17
    Views
    360

    Re: Bit of a Tricky One

    A1
    =IF(OR(Input!F103="large-22",Input!F103="large-25.4"),(VLOOKUP(B103,'B:\Menu Database\[BeerDatabase1.xlsx]Sheet1'!$A$3:$AN$40000,40,FALSE)),"")

    B1...
  14. Replies
    17
    Views
    360

    Re: Bit of a Tricky One

    There are formulas in A1 and B1 however, that either return a value or remain blank. The formula you gave me works, but even if both the formulas in A1/B1 cells are returning a blank cell D1 is...
  15. Replies
    17
    Views
    360

    Bit of a Tricky One

    Hello,

    I have a bit of a tricky one, maybe. I have formulas in both cells A1 and B1 that will either return a value or be left blank. What I would like to do is create another formula in cell D1...
  16. Replies
    2
    Views
    115

    Re: Simple IF Function?

    That was it, thank you!
  17. Replies
    2
    Views
    115

    Simple IF Function?

    Hi,

    Looking for a simple IF function, I hope lol.

    If cell A1 is popluated with the word "Can" I want the cell that this formula is in (B1) to populate with the data listed in A2. The only...
  18. Re: IFERROR + VLOOKUP + ??? - Returning a value only for a given selection.

    That the values under the headers could change and one of them would be a "10". I was able to figure out the formula though:...
  19. Re: If A1 is populated then vlookup another spreadsheet and populate, otherwise leave blank

    I'm still receiving the #N/A error in A2. Here's my formula:

    =IF(A1="","",VLOOKUP(A1,[BeerDatabase1.xlsx]Sheet1!$A$3:$L$27258,12))

    Not sure if it matter, but the value in A1 is text and not a...
  20. If A1 is populated then vlookup another spreadsheet and populate, otherwise leave blank

    Hi,

    I'm hoping someone can help me with a if, and/or, and vlookup formula. My formula would exist in A2 and perform a vlookup in another spreadsheet based on the value in A1, however, if A1 is...
  21. Re: Pulling Cell Info from Second Tab, but Need an IFERROR formula

    Actually, maybe you can help me with a more complicated version with a vlookup involved? Here's the formula:
    ...
  22. Re: Pulling Cell Info from Second Tab, but Need an IFERROR formula

    That did the trick, thank you!
  23. Re: Pulling Cell Info from Second Tab, but Need an IFERROR formula

    Office 16, not sure what version of excel that is.
  24. Re: IFERROR + VLOOKUP + ??? - Returning a value only for a given selection.

    =VLOOKUP(A1,[BeerDatabase1.xlsx]Sheet1!$A$3:$AE$27256,31,FALSE) in A3
    =VLOOKUP(A1,[BeerDatabase1.xlsx]Sheet1!$A$3:$AE$27256,32,FALSE) in A4...
  25. Pulling Cell Info from Second Tab, but Need an IFERROR formula

    Hi,

    I am pulling information from one tab of a workbook to another (tab1 and tab2). I'm using a basic formula (=Tab!A1), but if A1 is blank I would this formula to return an empty result instead...
Results 1 to 25 of 33
Page 1 of 2 1 2