Search:

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

1. Thread: IF EXACT Formula with multiple chains

by boojooo
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. Thread: IF EXACT Formula with multiple chains

by boojooo
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. Thread: IF/OR Formula Involving Multiple Cells

by boojooo
Replies
9
Views
167 Re: IF/OR Formula Involving Multiple Cells

Also forgot to thank Fluff, thank you!
4. Thread: IF/OR Formula Involving Multiple Cells

by boojooo
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. Thread: IF/OR Formula Involving Multiple Cells

by boojooo
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. Thread: IF/OR Formula Involving Multiple Cells

by boojooo
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. Thread: Bit of a Tricky One

by boojooo
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. Thread: IF/OR Formula Involving Multiple Cells

by boojooo
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. Thread: Bit of a Tricky One

by boojooo
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?

10. Thread: Bit of a Tricky One

by boojooo
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. Thread: Bit of a Tricky One

by boojooo
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. Thread: Bit of a Tricky One

by boojooo
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.

by boojooo
Replies
17
Views
360

A1

B1...
14. Thread: Bit of a Tricky One

by boojooo
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. Thread: Bit of a Tricky One

by boojooo
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. Thread: Simple IF Function?

by boojooo
Replies
2
Views
115 Re: Simple IF Function?

That was it, thank you!
17. Thread: Simple IF Function?

by boojooo
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. Thread: IFERROR + VLOOKUP + ??? - Returning a value only for a given selection.

by boojooo
Replies
5
Views
206 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. Thread: If A1 is populated then vlookup another spreadsheet and populate, otherwise leave blank

by boojooo
Replies
4
Views
145 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. Thread: If A1 is populated then vlookup another spreadsheet and populate, otherwise leave blank

by boojooo
Replies
4
Views
145 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. Thread: Pulling Cell Info from Second Tab, but Need an IFERROR formula

by boojooo
Replies
7
Views
188 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. Thread: Pulling Cell Info from Second Tab, but Need an IFERROR formula

by boojooo
Replies
7
Views
188 Re: Pulling Cell Info from Second Tab, but Need an IFERROR formula

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

by boojooo
Replies
7
Views
188 Re: Pulling Cell Info from Second Tab, but Need an IFERROR formula

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

by boojooo
Replies
5
Views
206 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. Thread: Pulling Cell Info from Second Tab, but Need an IFERROR formula

by boojooo
Replies
7
Views
188 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