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 blank I want A2 to return a empty cell value. I know this is possible, but I'm driving myself nuts driving to figure out which combination of IF, vlookup, and possibly and/or to get it working.
Thank you.
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 blank I want A2 to return a empty cell value. I know this is possible, but I'm driving myself nuts driving to figure out which combination of IF, vlookup, and possibly and/or to get it working.
Thank you.