How can lookup value in multi tabs sheet

[anonymous]

Hi Anyone,

I have a four tab in the one sheet. I want lookup value in the form column. Every sheet very similar in the key columns included same sheets.

1:- Cargo

2:- Box

3:- Delivered

4:- Pending

[Lynn]

Hi @Sayad

Have you searched the forum or the documentation for Lookup?

[Joseph_Seddik]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_R… - Google Cloud Community

[anonymous]

Look at this screenshot, LR NO IS KEY COLUMNS. all sheet is similar.

Lookup data LR NO TO DEST STATE.

.