This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

LOOKUP FROM OTHER SHEET REFERNECE

Posted on 03-17-2022 04:42 AM
GOKULR
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

@Joseph_Seddik 

@Aurelien 

I NEED FORMAULA FOR APP SHEET TO GET DATA OF BIN NUMBER FROM MASTER TO DATA ENTRY SHEET

MASTER PAGE CONTAIN ALL SKU's AND BIN NUMBER

WHEN WE ENTER THE SKU IN THE DATA ENTRY SHEET I NEED THE BIN NUMBER TO GET AUTO UPDATED BASED UPON THE MASTER SHEET

0 3 52
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
Justlookinghere
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

You can probably make the bin number column as your primary key and then the entry sheet columns as your reference. Just a thought..

Posted on --/--/---- --:-- AM
Aurelien
Google Developer Expert
Google Developer Expert
Reply posted on --/--/---- --:-- AM

Hi @GOKULR 

 

In addition to @Justlookinghere's suggestion, here is some reading:

https://help.appsheet.com/en/articles/895267-data-the-essentials

You may find plenty of useful information in it 🙂

Posted on --/--/---- --:-- AM
Joseph_Seddik
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

And this 🙂 

https://help.appsheet.com/en/articles/961426-references-between-tables

Top Labels in this Space