Usage of IF formula between sheets

Luigi Guidobono Cavalchini

Hi,

I am using the IF formula to obtain a result in my sheet if the code is the same i have in another sheet.

Example: Smartsheet1, If in cell A1 I have code "123", i need to verify if the same code appears in Smartsheet 2 and if yes i want that in Cell A2 of Smartsheet1 is reported the info that i can read in cell A2 of the Smartsheet 2

Is the example clear?

I tried and i have this formula:

=IF([Document Number]1 = {SAP OPS REPORT Intervallo 1}; {SAP OPS REPORT Intervallo 2}; NA)

But in the cell i get: #UNPARASABLE

Can you please address me?

Thanks

Luigi

Andrée Starå

@Luigi Guidobono Cavalchini

Try this one.

=VLOOKUP([Document Number]246; {SAP OPS REPORT Intervallo 4}; 17;0 ) 

Did it work?

Andrée Starå

Hi @Luigi Guidobono Cavalchini

If I understand you correctly, you’ll need to use a VLOOKUP or and INDEX/MATCH combination structure to make that work.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Luigi Guidobono Cavalchini

Hi,

thank you for the feedback, indeed VLOOKUP is the correct formula to bu used, and i do normaly use in excel, but here it gives me still an error.

My formula here is:

=VLOOKUP([Document Number]246; {SAP OPS REPORT Intervallo 4}; 17; ) but in the cell i always get: #unparseable

Andrée Starå

@Luigi Guidobono Cavalchini

Try this one.

=VLOOKUP([Document Number]246; {SAP OPS REPORT Intervallo 4}; 17;0 ) 

Did it work?

Luigi Guidobono Cavalchini

Hi

no it says: #invalid ref

Luigi Guidobono Cavalchini

Hi,

i did it again, and yes!!! it works!!!!

Many many thanks!

Andrée Starå

@Luigi Guidobono Cavalchini

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!