# Usage of IF formula between sheets

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

Thanks

Luigi

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• 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

• Hi

no it says: #invalid ref

• Hi,

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

Many many thanks!

• ✭✭✭✭✭✭

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!