Need help with VLOOKUP

By JBH •

For 12200-235-16SS0101-CIP-1 find 12200-235-16SS0101-CIP and show me what is in column 9.

I get it to work because the -1 is not on the end.

I am trying to use this formula =VLOOKUP(N1109,'[3148001 rev.E K-home-BEH.xls]Sheet1'!$G:$O,9,TRUE)

N1109 is where 12200-235-16SS0101-CIP-1 is

[3148001 rev.E K-home-BEH.xls]Sheet1'!$G is where 12200-235-16SS0101-CIP is.

HELP!

Share : Share

0 comments

More from Qatar Living

Qatar’s top beaches for water sports thrills

Let's dive into the best beaches in Qatar, where you can have a blast with water activities, sports and all around fun times.

Most Useful Apps In Qatar - Part Two

This guide brings you the top apps that will simplify the use of government services in Qatar.

Most Useful Apps In Qatar - Part One

this guide presents the top must-have Qatar-based apps to help you navigate, dine, explore, access government services, and more in the country.

Winter is coming – Qatar’s seasonal adventures await!

Qatar's winter months are brimming with unmissable experiences, from the AFC Asian Cup 2023 to the World Aquatics Championships Doha 2024 and a variety of outdoor adventures and cultural delights.

7 Days of Fun: One-Week Activity Plan for Kids

Stuck with a week-long holiday and bored kids? We've got a one week activity plan for fun, learning, and lasting memories.

Wallet-friendly Mango Sticky Rice restaurants that are delightful on a budget

Fasten your seatbelts and get ready for a sweet escape into the world of budget-friendly Mango Sticky Rice that's sure to satisfy both your cravings and your budget!

Places to enjoy Mango Sticky Rice in high-end elegance

Delve into a world of culinary luxury as we explore the upmarket hotels and fine dining restaurants serving exquisite Mango Sticky Rice.

Where to celebrate World Vegan Day in Qatar

Celebrate World Vegan Day with our list of vegan food outlets offering an array of delectable options, spanning from colorful salads to savory shawarma and indulgent desserts.

My account

My saved ads

My saved searches

Dashboard

Manage my ads

Logout

Need help with VLOOKUP

More from Qatar Living