How to solve error #N/A in my project

Almost certainly...

the No pemesanan value in one sheet will be stored as TEXT and in the other as a NUMBER.

Select each No Pemenasan column (separately0.

Date/Text to columns/Finish.

That should solve it.

Can you please be patient? It has only been six minutes since your last post - there are others here needing help. Please wait your turn patiently,

Post a sample file. Then I can test it. I can do NOTHING with a picture.

Stop adding pointless posts to the thread. Your English is fine. Wait patiently until someone responds with assistance.

EDIT: See post #8.

If you are using Google sheets, I can not help you. I do not use GS.

If you are using Excel, read the instructions (yellow banner - top) and attach the Excel file HERE.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

You are referencing the wrong sheet in the formula. Change this:

=VLOOKUP(B2,'File Latihan'!$A$1:$D$11,2,FALSE)

to this:

=VLOOKUP(B2,'Data Referensi'!$A$2:$D$11,2,FALSE)

In E2:

=HLOOKUP(D2,'Data Referensi'!$B$14:$E$15,2,0)

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

wait why I am still getting errors like this
Attachment 845846
Attachment 845847

You didn't fix the range:

=VLOOKUP(B2,'Data Referensi'!$A$2:$E$16,2,FALSE)

The $ signs are needed.

If that doesn't fix it, attach the WORKBOOk (don't use screenshots in future, please).

Please try: in E2 and copy down:

Formula:

=HLOOKUP(D3;'Data Referensi'!A$15:E$16;2;FALSE)

Same issue - you need to FIX the range with $ signs. Workbook fixed.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Originally Posted by misbahskuy

Attachment 845854
still error

Not in the file I attached. Check the array is correct. This is all user error, I am afraid.

You have been told NOT to post screenshots. WORKBOOKS, please.

Did you try the formula in Post #22?

Or upload your workbook via Go Advanced and Manage attachments? (see yellow banner at the top of this page).

I can not download your attachment in Post #25 (invalid attachment specified)

The reference should be:

'Data Referensi'!$B$14:$E$15

Come on - you have to start looking carefully at what you are doing. You should have been able to spot this yourself!

Pay closer attention to what you are doing.

At last!

If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.