IF function combined with Vlookup in 2 different smartsheets

Silvia C Rodriguez

Hello!

I have another beginner question. Is it possible to combine an If conditional with a Vlookup?

This is my scenario:

I have 2 sheets:

Summary and Form.

Columns in each sheet are:

Summary Sheet:

-Column Name

-Column Question #1

Form Sheet:

-Column Name

-Column Quarter

-Column Question 1

The result that I need:

I would like to bring the value in Column Question 1 (from the Form Sheet) to the summary sheet, but only if the quarter answer is x.

Is this possible?

I hope I explained myself.

Thank you!

Find more posts tagged with

Formulas

Comments

Paul Newcome

Screenshots may help us better find an answer for you.

Silvia C Rodriguez

Hi Paul,

I attached a print screen.

Thank you for your help.

Vlookup formula combined with IF.JPG

Paul Newcome

I just want to make sure I'm clear on what exactly you're looking for...

You want the information from the bottom screenshot to determine which section of the top screenshot it goes in?

In answer to the first part of your question: There are no functions that I am aware of that will place a row under a specific parent row within a sheet. There are a few different options for workarounds though. One would be sorting within the sheet. Another option is having a summary sheet with all quarters combined (no particular sort order), and having a report for each quarter that looks at your sheet.

In answer to the second part: It is possible to use VLOOKUP within and IF statement as well as an IF statement within a VLOOKUP.

Sorry if this isn't the answer you're looking for. I'm having a little trouble figuring out exactly how your original post and your screenshots fit together.

If all you are trying to accomplish is to populate a specific cell based on specific criteria you would not necessarily need a VLOOKUP function. It would be something along the lines of:

=IF({Form Sheet Range 1} = "2 Quarter", {Form Sheet Range 2})

{Form Sheet Range 1} would be the cell you want to use to determine the criteria.

{Form Sheet Range 2} would be the cell you want to pull the data from.

There are a few issues with this particular setup.

1. You would have to create new range references for each cell.

2. You can only have 100 unique range references on a sheet. Since you have 2 for each row, you would cap it out in just 50 rows.

Silvia C Rodriguez

You gave me the answer. Yes!

Thank you so much.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…